An interactive filter that displays list of users according to the chosen group and apply to reports

[sreeshsurendran]

Hi all,

Have a requirement related to Interactive filters and reports: 

Requirement: Need an interactive filter which shows list of users based on the group selected and if the user has any Incident assigned, show the results in reports.

Solution I thought: Create a cascading filter, which shows the groups (filter it with type), then have the list of members based on the selected group and select the user from the drop-down. But this won't apply on my reports as reports are coming from Incident table

Any leads/help on the above would be helpful

Thanks

Sreesh Surendran

[Ankur Bawiskar]

@sreeshsurendran 

yes you are on right track

Cascading Interactive Filters - Office Hours - Aug 14 Recap 

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[sreeshsurendran]

Thanks @Ankur Bawiskar , I was able to setup the first two levels of Cascading filters, but not able to setup the third level (Manager's Manager).

Below are the details: 

• 1st Level Cascade - Reference Table: sys_user_group
• 2nd Level Cascade - Reference Table: sys_user_grmember and Parent reference field: Group
• 3rd Level Cascade - Reference Table: sys_user and Parent reference field: Sys ID

Let me know if the above is correct.

Regards
Sreesh Surendran

[Ankur Bawiskar]

@sreeshsurendran 

not sure on the third level