Reference Qualifier

[David Boom]

I have 2 variable referencing to same table. Variable A and B.

The table they are referencing to have parent child relationship between records like Incidents and child incidents.

Requirement is when I select some value in A, B should show only child records of A.

[Dr Atul G- LNG]

Hi @David Boom 

You can use the OOTB functionality here, such as the assignment group and assigned to fields. It's part of the out-of-the-box setup. Please check and confirm if it's done.

[JenniferRah · Accepted solution]

You can add a reference qualifier like this to variable B, where "fieldname" is the field in the reference table that shows the relationship to the parent and "fieldA" is the name of your variable A.

javascript: "fieldname=" + current.variables.fieldA;

[David Boom]

@JenniferRah can we add a filter condition as well in this?

[JenniferRah]

Sure. It would just look something like this. As long as the string returns the entire search string, it should work.

javascript: "field1=value1^fieldname=" + current.variables.fieldA;