we have configured a repeating grid for open assignment view of user with Data page as source. The Data Page is sourced by RD.
The RD is sorted by Assignment urgency and due date. The due date is on work page. We have a requirement where the user should decide which one out urgency and due date, will take higher priority and later will have secondary priority.
Already tried approach:
1. Source the Data page with another RD and control both sources based on user preference with When rule.
It is not good approach as we have many such report requirements.
2. use post processing of Data page and use obj-sort for sorting.
Not a good approach as we have to loop on all the results as due date is on work page. This will have serious performance issues as results can be huge as the all the reports Sections are shown on user portal on load.
Kindly suggest any other approach by which these requirement can be achieved