Interactive filter help

[Dean1]

Hi Everyone,

I am attempting to configure an interactive filter on a dashboard, which displays group names which are:

Type: contains > ITIL [AND]
Manager: is (dynamic) > Me [OR]
Group Member: is (dynamic) > Me

I have successfully got the components in green working above by using the reference table of Group [sys_user_group], but am unsure how to include the OR statement for the group member components.

Can anyone please point me in the right direction?

Thanks.

[Community Alums]

Hello Dean,

Group member is not part of table Group [sys_user_group], hence you can't add that OR condition. You need to use Group Members [sys_user_grmember] table. PFB screen shot. 

Regards, 

Akshay 

[Dean1]

Hi Akshay,

Thanks for the information.

My goal is to have a drop down list on the dashboard which allows selection of the filtered Assignment Groups to filter various reports on the page relating to Tasks, Incidents Changes and SLAs etc

I am using a Interactive Filter of type: Reference, and have set the Reference table to Group Member [sys_user_grmember] as you suggested. I am able to create the query that you specified, but the values displayed are all GUIDs and the Interactive Filter Preferences I am a setting are returning an error stating: Reference field "assignment_group" is not of type "sys_user_grmember"

Any suggestions?

Thanks

[Community Alums · Accepted solution]

Hello Dean,

Now, I understand your requirement. Thanks for the elaboration. You can keep "Group [sys_user_group]" table in Interactive filter. 

I have modified "User" condition which suppose return list of groups whose I am part of. I am using Sys ID condition which will brings list of groups whose I am part of.  

PFB screen shot. I hope it will help you.

Thanks & Regards,

Akshay

[Dean1]

Hi Akshay,

Thankyou so much for your help. The filter is now working as needed.

Much appreciated!