Issue with sorting the records
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2024 10:46 AM
Hi Team,
I'm facing an issue in sorting the records.
For eg. I have 6 records of different change types and their count like "Normal - 2", "Emergency - 1", "Standard - 3".
I don't want the sort based on alphabetical asc or desc. I want customized sort to be as Normal - Standard - Emergency.
How to get the records on a custom sort?
Any help or idea is appreciated.
- Labels:
-
Change Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2024 11:24 AM
Hi @sujitha16,
For custome sorting , you need some custom column with constant values for N,E and S type changes.
-Thanks,
AshishKM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2024 11:42 AM
Thank you for the response!
If possible can you share basic outline of the script to achieve it or any reference links to start with and get an idea.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-09-2024 11:50 AM
create a new field (number type ) on change_request table ( hidden on form )
set this field value on new change ( update for existing changes )
1 for Normal
2 for Standard
3 for Emergency
now table has column to apply sort … all CHG will show in order of 1 then 2 then 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-11-2024 08:25 AM
@sujitha16 , Let us know if you have any other query or the provided info helped to determine the custome solution. if yes, please accept the solution.