Bỏ qua để đến Nội dung
Menu
Câu hỏi này đã bị gắn cờ
1 Trả lời
2720 Lượt xem

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.

Ảnh đại diện
Huỷ bỏ
Câu trả lời hay nhất

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


Ảnh đại diện
Huỷ bỏ
Bài viết liên quan Trả lời Lượt xem Hoạt động
2
thg 9 22
2962
0
thg 4 24
1252
0
thg 2 23
3769
5
thg 11 22
8004
1
thg 4 16
3648