Hi guys
I have a Read-only grid with 5 columns
One of the column is Status, which have only 4 values like Rejected, In progress, Completed, Pending
So now I need to make status column to show in an order {Rejected, In Progress, Pending, Completed}
Sorting only supports Ascending and Descending order
How to create custom sorting to appear in this order {Rejected, In Progress, Pending, Completed}
Thanks
Discussion posts and replies are publicly visible
The best way to do this is to store the values in a reference table with an extra column for "order". Then, you can use the order column for sorting instead of sorting alphabetically. For instance, your table might look like this:
id | label | order
1 | In Progress | 2
2 | Pending | 3
3 | Rejected | 1
4 | Completed | 4