question Re: Reference Interactive Filter | Create a Reference on the Referenced Table in Platform Analytics forum

Reference Interactive Filter | Create a Reference on the Referenced Table

mdandrade — Fri, 26 Jun 2020 13:46:46 GMT

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?

Re: Reference Interactive Filter | Create a Reference on the Referenced Table

Adam Stout — Fri, 26 Jun 2020 15:31:36 GMT

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.

Re: Reference Interactive Filter | Create a Reference on the Referenced Table

mdandrade — Fri, 26 Jun 2020 15:58:11 GMT

CORRECTION

It works! Thanks!

Re: Reference Interactive Filter | Create a Reference on the Referenced Table

Rohit8 — Thu, 05 Nov 2020 04:15:39 GMT

This solution worked perfectly! Thank you.

Re: Reference Interactive Filter | Create a Reference on the Referenced Table

Jack Littlewort — Wed, 26 Jan 2022 15:57:45 GMT

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.