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.

[Peter Bodelier]

Hi @Paul H2 

What exactly do you want to create?

You're talking about Related list conditions and interactive filters, which are two separate things.

[Paul H2]

Hi Peter,

To be exact, I am hoping to create a related list condition that looks at two fields of the same table.

Basically, instead of the related list condition saying "Problem -> Assigned to", would there be a way to get it to act as "Problem -> Assigned to" and "Problem -> Problem Coordinator", at the same time?

[AndersBGS]

Hi @Paul H2 , 

If you create a two interactive filter references both to the problem table where one is problem coordinator and the other one is assigned to, the when you utilize this interactive filter, it will only show show values when problem coordinator and assigned to have the same value. So basic, it's possible, but is this what you want and is this really the business requirement?

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

Best regards

Anders

[Paul H2]

Hello Anders,

This is not the business requirement, as it is possible for these two columns to have different values - hence the need for a filter that would look at both columns and return a value in either one.

For extra context, "problem coordinator" is a field that will be disused going forward, with "assigned to" being solely used going forward. The goal is to have something that can look at both even after this change has been implemented, as a way of looking at anybody who has ever been involved with a problem ticket.