Skip ke Konten
Menu
Pertanyaan ini telah diberikan tanda
1 Balas
3030 Tampilan

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
Buang
Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
2
Sep 22
3329
0
Apr 24
1615
0
Feb 23
4137
5
Nov 22
8401
1
Apr 16
3985