Reference qualifier - Opened by is same as variable user field on catalog item?

[Ahmet1]

Hi, 

We have a catalog item form that has a variable that references sys_user (user field), field is 'Contact'.

We have another field to select a Request Item from sc_req_item table.

We want to put a Reference qualifier on here to only show RITMs where Opened by on sc_req_item = Contact field that is on this catalog item form.

I have tried advanced reference qual and done "opened_by=current.variables.contact" also tried "opened_by=variables.sysID" none worked , is this possible?

[Manmohan K]

Hi @Ahmet1 

Try with below code in advanced reference qualifier:

[Ankur Bawiskar]

@Ahmet1 

this should work

javascript:'opened_by=' + current.variables.contact;

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ahmet1]

Thanks Ankur, this works however how do I add multiple filters with this? such as adding Active=true aswell? I tried ^ in between but its not doing the active ones

[Ankur Bawiskar · Accepted solution]

@Ahmet1 

like this

javascript:'opened_by=' + current.variables.contact + '^active=true';