Přejít na obsah
Menu
You need to be registered to interact with the community.
This question has been flagged
1 Odpovědět
2692 Zobrazení

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
Zrušit
Nejlepší odpověď

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
Zrušit
Related Posts Odpovědi Zobrazení Aktivita
2
zář 22
2954
0
dub 24
1247
0
úno 23
3759
5
lis 22
7996
1
dub 16
3643