Sorting alphanumeric field in list view

Go to solution
lakshmi_patel
Kilo Explorer

‎07-31-2017 10:25 PM

Hi All,

I have a string kind of field and i need to sort this numerically in ascending order, right now it is displaying all starting with 1 first then the ones starting with 2 and so on. I want to show the numbers in ascending order. Any suggestions will be appreciated on this.

Screen Shot 2017-08-01 at 10.52.28 AM.png

Regards

Lakshmi

Preview file
30 KB
0 Helpfuls
  • 1,851 Views
1 ACCEPTED SOLUTION

Go to solution
antin_s
ServiceNow Employee
ServiceNow Employee
In response to lakshmi_patel

‎07-31-2017 10:39 PM

Hi Lakshmi,



For this to work, you need to have the String Values like 01, 02, 03, ..... 11,   43. If you think you might have 3 digit, you should have it as 001, 002, 003, ...etc.



Hope this helps. Mark the answer as correct/helpful based on impact.



Thanks


Antin


View solution in original post

6 REPLIES 6

Go to solution
PrashantLearnIT
Giga Sage

‎07-31-2017 10:30 PM

Hi Lakshmi



It is coming as per ascending only as far as i see your screenshot.


********************************************************************************************************
Please appreciate the efforts of community contributors by marking the appropriate response as the correct answer and helpful. This may help other community users to follow the correct solution in the future.

********************************************************************************************************
Cheers,
Prashant Kumar
ServiceNow Technical Architect


Community Profile LinkedIn YouTube Medium TopMate
********************************************************************************************************
0 Helpfuls

Go to solution
lakshmi_patel
Kilo Explorer
In response to PrashantLearnIT

‎07-31-2017 10:35 PM

Hi Prashant,



It is first showing all names starting with 1, then all starting with 2.   The sequence is like shown below:



1


11


12


2


21


24


3


31


35


4


41


43



I hope this clarifies my issue.


2 should be shown after 1, not after 12.



Regards


Lakshmi


0 Helpfuls

Go to solution
PrashantLearnIT
Giga Sage
In response to lakshmi_patel

‎07-31-2017 10:38 PM

HI Lakshmi,



What is the data type for that field?


********************************************************************************************************
Please appreciate the efforts of community contributors by marking the appropriate response as the correct answer and helpful. This may help other community users to follow the correct solution in the future.

********************************************************************************************************
Cheers,
Prashant Kumar
ServiceNow Technical Architect


Community Profile LinkedIn YouTube Medium TopMate
********************************************************************************************************
0 Helpfuls

Go to solution
lakshmi_patel
Kilo Explorer
In response to PrashantLearnIT

‎07-31-2017 10:39 PM

Hi Prashant,



It is string.


0 Helpfuls