Can an interactive filter reference two fields of the same table?

[Paul H2]

Hi everyone,

I have been tasked with creating an interactive filter that consolidates two fields of a problem table, both of which reference the sys_user table. However, I notice that I am only allowed to reference a single field of a related table when I create a related list condition. Other than getting a new field created that consolidates this information for me, would there be any other way to build this interactive filter as (or close to) requested?

Thank you in advance for any assistance.

[AndersBGS]

Hi @Paul H2 ,

No, that is not possible. An interactive filter needs to reference a table and a column. If you reference two columns in same table, it will look at both columns to see if it has the same value. The utilize reference filters, you should instead create two filters. One is looking at first colum, second is looking at second column on the table. 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders