Have to add some more filters to advance reference qualifier

[Roxi1]

We have two reference variables and two variables are referring to different tables which has relation between those tables. for the second variable defined condition in advance reference qualifier to depend on first variable. And now our requirement is to add some more filters to this existing condition in reference qualifier to avoid showing retired records from the second variable.

this is the existing Advance reference qualifier which makes based one selecting first variable- javascript:'variable1='+current.variables.variable1;

have to merge this  state!=retired^statusNOT INobsolete,retired

This is the query copied from list view for reference:

[Sagar Pagar · Accepted solution]

Hi @Roxi,

Try this in advanced reference qualifier.

javascript:"variable1="+current.variables.variable1+"^state!=retired^statusNOT INobsolete,retired";

Thanks,
Sagar Pagar

[Ankur Bawiskar]

Hi,

this should work fine

javascript:'variable1='+current.variables.variable1 + '^state!=retired^statusNOT INobsolete,retired';

Regards
Ankur