Reference Interactive Filter | Create a Reference on the Referenced Table

[mdandrade]

I've created a reference interactive filter with reference table = sys_user_group. The filter is placed on a dashboard with 3 reports with source tables of: sys_group_has_role, sys_user_grmember, and sys_user_group. I want the interactive filter to apply to all 3 reports, but am only able to add interactive filter references for the sys_group_has_role and sys_user_grmember tables. I've attempted to create an interactive filter reference on the sys_user group table where:

reference table = sys_user_group

reference field = Sys ID

However, I get the error "Reference field "sys_id" is not of type "sys_user_group"". Is there a way to filter a report using an interactive filter with a matching reference table?

[Adam Stout · Accepted solution]

I believe this will work once configured, but there is a BR that presents it from being configured.  For the time being, you may need to disable that BR.

[mdandrade]

CORRECTION

It works! Thanks!

[Jack Littlewort]

How did you end up getting this to work.

I've manually set the table to rm_sprint and the field to sys_id but it still doesn't work for me.

[Rohit8]

This solution worked perfectly! Thank you.