Interactive Filters - Assignment Group, Assigned To

[dharani2607]

Hello,

I need to add an interactive filter in homepage dashboard, where user can select multiple assignment groups (only he's part of), assigned to (based on selected assignment group) for viewing the reports in dashboard.

Something similar to below one,

Thanks

[Mohith Devatte]

hello @dharani2607 ,

you can refer this link on how to create it .

You need to create a reference type interactive filter which is on sys_user_group table 

https://docs.servicenow.com/bundle/sandiego-now-intelligence/page/use/dashboards/task/t_CreateARefer...

Hope this helps 

please mark my answer correct if this helps you

[Maharshi Chatte]

Hi @dharani2607 ,

You have to create a reference filter with multiple input selection in the sys_user_groups table as reference table.

However if you want to show the users based on groups you may have to use a cascading interactive filter in place of reference filter.

Regards,

Maharshi

[dharani2607]

yes this worked, but how to use cascading interactive filter to get users

[Maharshi Chatte]

Hi,

For cascading filter you have to use sys_user_grmember table .

Then you need to create a cascading filter to show the groups.Cascading filter will come as a related list after you same the filter details first

And then you need to create another cascading filter to show the members.

However this will aloo you to select only single group/member at a time. So it is better to create 2 reference filter one for group and other for user.

*Please mark the answer/helpful if it works

Regards,

Maharshi