I need to create a custom sort for a data table column
I have to fix a table report definition that lprovides a list of contracts along with their stage. The business requirement states that sorting the contract stage column should not sort it in alphabetical order, but it should sort it in the order in which a contract goes through these phases (ie - Initiation, Proposal, Contracting, Follow-up, Closing). I have been at this for hours and I'm fairly new to Pega. Any help is appreciated.
Is your requirement to generate the report with record sorted in the order of Stages, or your report needs to follow that kind of sorting when user clicks on that Contract Stage column?
If it is about the latter one, you need to define an Override Sort function for that property, presented as Contract stage column on report. Please refer to Work-Cover-.pyID property (Advanced tab > Override Sort function), and the OOTB functions in Sort library (RS: Pega-RULES) for reference.
You should be creating your custom sort function in your custom library and your application RS.