I created an interactive filter on the sys_user_group table which loads up all of the groups that a given user manages as well as the groups of the managers under them. This is accomplished by calling a script include in the interactive filter. Essentially whoever opens the dashboard is used in the query to find all of the assignment groups. The problem is that if management is using the dashboard it will only show assignment groups belonging to the person who is currently displaying the dashboard. Below, when I view the dashboard it allows me to pick from the groups I manage or which belong to people I manage. I would like to improve this by have the ability to select a user and then the script include runs which will populate the various groups. Cascading filters doesn't work because there is no checkbox option. I feel like I need a custom filter that a) builds a choice list of all users and b) once a user is selected I can call the script include to gather all of the groups that user manages. I just can't find any examples to work off.
The end goal is a dashboard which has various reports that extend the task table (incident, change, etc). Select a user and show records that belong to the groups they manage the groups that report to this user.
