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

Ahmet1
Tera Expert

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?

1 ACCEPTED SOLUTION

@Ahmet1 

like this

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

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

View solution in original post

7 REPLIES 7

Hi Ankur, that didn't work unfortunately

My mistake, I did not replace the word colon with :  all good thanks for help

Hi Ankur, Apologies! that didn't work actually! I was testing incorrectly. I am getting ALL request items on the list when I use this reference qualifier.