Is there any way to apply multiple sorting rules on section page?
For example, on case page I need to sort the list by priority first if the priority is same then, apply the status rule.
One more thing I want to apply this rule as by Default so every time any user visit case section page, the user by default sees the list in given as above manner.
If anyone has any information regarding the same do let me know.
As we can see there are three main parameters that are responsible for grid sorting: sortColumn, sortColumnDirection and sortColumnIndex. Each of them calls either the sortColumn function or changeSorting function from the GridUtilitiesV2 schema where the value is set for these attributes. And the problem is that these functions can only get one column as an argument.
Overriding this logic won't be an easy task since there are two functions and the DataGrid object that should be modified. Our core R&D team has a problem registered on their end to make it possible to sort the grid using several columns and this idea is added to the system functionality improvement roadmap. So it's better to wait until the out-of-the-box solution is deployed and tested.
Currently there is no possibility to do that with the help of standard filtration tool. I will create a request to our R&D team so they could add this functionality to the OOB version. Thank you for this suggestion!
Also please note that you can use sorting tool in a section that also allows to show first 10 records based on sorting direction. Also you can use tags so to mark 10 records that can be found in future if needed.
Also you can add a field on the page (integer type) that can be auto incremented upon records adding. You will also need to add a system setting that stores current number of this field. At the very beginning it will be 0. After that you need to create a business process that will update the value of added on the page field for the new record with the value of that system setting and after that increase the value of system setting to n+1 where n - is a current value.
