Interactive Filter using a dot-walked field

[aguanci]

Hi All,

I am attempting to create an interactive filter for Company using a dot walked field and am having a bit of trouble. The dashboard uses reports based on sn_hr_core_case and the asmt_assessment_instance tables. The Reference table I am using is sn_hr_core_case and the Interactive Filter reference I am attempting to use is sys_user with a field of Company. However, I am getting the error of: Reference field "company" is not of type "sn_hr_core_case"

I have also tried to do the reverse and use sys_user as the Reference table and sn_hr_core_case as the Interactive Filter Reference. However, that produced an error message as well. Is it possible to create an interactive filter from a dot-walk field?

[Aditya Raute]

Can you share the error message and the Interactive Filter References you declared?

[aguanci]

Here is the Reference:

Here is the Interactive Filter Reference:

[jaheerhattiwale · Accepted solution]

@aguanci Follow below steps

Create interactive filter which references the company table

After creating interactive filter, scroll down to related lists

In "Interactive filter references" related list add the table and company referencing fields

Below image shows 2 records one without dot walk and one with dot walk

Please mark as correct answer if this solves your issue.

[aguanci]

This worked! Thank you for your help!