added the screenshot to the question

Hi,

Applied the required query in list view for your table and just copy it and add it to Advanced reference qualifier field.

javascript:"add_copied_query_here";

Thanks,
Sagar Pagar

as i said, there is already a condition defined to check the parent variable value and display the values in dependent variable.

but now our requirement has to add another conditions for filtering the retired records

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:

Hi,

this should work fine

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

Regards
Ankur