Issue with sorting the records

[Sujatha V M]

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. 

[AshishKM]

Hi @Sujatha V M,

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

-Thanks,

AshishKM

[Sujatha V M]

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. 

[AshishKM]

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 

[AshishKM]

@Sujatha V M , 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.