The problem
...
For example, by default, a user who is the manager of other users and is also a workflow approver (for a different set of users) can see:
Their own draft applications
Submitted applications where they are the subject
Submitted applications from others that are pending their approval (the application is at an approval level where they are an approver)
Submitted applications from others that are on an assignment where they are an approver at some level (this overlaps with the previous point)
Applications submitted by their reports
When loading the applications dashboard view, we need to find the union of all of these visible applications, across all of the workflow assignments in the system. This needs to be done in a single query so that it can be properly sorted and paged.
...
There is a scheduled task called Regenerate role capability maps to optimise application dashboard loading that runs every hour to update the map.
The map is also generated the first time the applications dashboard is loaded, if it doesn't already exist.
...