- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2023 06:05 AM
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?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2023 06:26 AM
like this
javascript:'opened_by=' + current.variables.contact + '^active=true';
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2023 06:29 AM
Hi Ankur, that didn't work unfortunately
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-23-2023 06:56 AM
My mistake, I did not replace the word colon with : all good thanks for help
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-22-2023 07:55 AM
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.