Issue with sorting the records

sujitha16
Kilo Patron

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. 

7 REPLIES 7

AshishKM
Kilo Patron

Hi @sujitha16,

For custome sorting , you need some custom column with constant values for N,E and S type changes. 

-Thanks,

AshishKM

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. 

 

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 

@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.