Ir al contenido
Menú
Se marcó esta pregunta
1 Responder
2684 Vistas

Hey all, I've been trying to sort Analytic accounts, but they are sorting in a strange way, unlike the other things.

For EG: I want to sort: 1, 2, 3, 4, 5, 10, 20.
But on Analytic accounts, by using References, it is sorting up as: 1, 10, 2, 20, 3, 4, 5.


Screenshot attached for more guidance: 

http://imgur.com/a/lmTa0

http://tinypic.com/r/153tc0z/9


Any help would be much appreciated. Many Thanks.

Avatar
Descartar
Mejor respuesta

This because References field is char field, and ordering is different from integer field, must put all code with same digits number.

Example convert: 1, 2, 3, 4, 5, 10, 20

To:  01, 02, 03, 04, 05, 10, 20


Avatar
Descartar
Publicaciones relacionadas Respuestas Vistas Actividad
2
sept 22
2953
0
abr 24
1242
0
feb 23
3754
5
nov 22
7992
1
abr 16
3635