- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2020 02:33 AM
Hi
I wanted to add a filter condition to a variable in catalog item but there is already an advanced reference qualifier present.
now I want to add this filter condition operational_status=1 along with the present condition.
javascript: current.variables.v_BLine2 == '' ? '': 'u_group='+ current.variables.v_BLine2;(existing condition)
I tried this way but didnt get the result
javascript: current.variables.v_BLine2 == '' ? '': 'u_group='+ current.variables.v_BLine2+"^operational_status=1";
Any suggestions..?
Solved! Go to Solution.
- Labels:
-
Scripting and Coding
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2020 04:16 AM
Hi,
is your existing ref qualifier working fine?
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2020 02:47 AM
Hi,
update as below
javascript: current.variables.v_BLine2 == '' ? '': 'u_group='+ current.variables.v_BLine2 + '^operational_status=1';
Did you check the variable is reference type and has that column in that table
please share variable configuration image and ref qualifier image
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2020 03:30 AM
the variable is reference type and table has the column operation
copied the query from here.
And i tried this condition also javascript: current.variables.v_BLine2 == '' ? '': 'u_group='+ current.variables.v_BLine2 + '^operational_status=1'; but didnt work
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-09-2020 04:16 AM
Hi,
is your existing ref qualifier working fine?
Regards
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-13-2020 10:09 AM
Hope you are doing good.
Did my reply answer your question?
If so, please mark appropriate response as correct & helpful so that the question will appear as resolved for others who may have a similar question in the future.
Thanks!
Ankur
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader