Have to add some more filters to advance reference qualifier

Roxi1
Tera Contributor

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:

 

1 ACCEPTED SOLUTION

Hi @Roxi,

Try this in advanced reference qualifier.

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

 

Thanks,
Sagar Pagar

The world works with ServiceNow

View solution in original post

11 REPLIES 11

Mohith Devatte
Tera Sage
Tera Sage

hello ,

can you try this

javascript:state!=retired^statusNOT INobsolete,retired

please mark this helpful  if this solves the issue 

thanks

Hello Mohith,

thanks for response. we have to merge both as one to make work

javascript:'variable1='+current.variables.variable1; (Existing condition)

state!=retired^statusNOT INobsolete,retired (have to merge)

yeah so for this 

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

you can write like this in AND fashion 

if it is OR fashion you can write like below code

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

Please accept the solution if it solves the issue

i tried to update the same in advance reference qualifier but not working, still the reference variable showing the retired records in it