- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
Regards
Lakshmi
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
********************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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
********************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-31-2017 10:39 PM
Hi Prashant,
It is string.