
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2017 08:40 AM
I created a table that has a list of item descriptions, in which I only want certain descriptions to be displayed based on the category. I submitted a previous question and it was suggested to use reference qualifiers. So I did, now the dilema is one of the categories has about 19 descriptions that I want to be visible if that category is selected. I had no issue setting up the reference qualifier but after the 4th value, all of the other values are removed.
See screenshots below:
FYI: I tried different options such as Item Desciption CONTAINs and then kept selecting OR,
I tried Item Description IS and the exact name of the description, followed by selecting OR,
I tried Item Description is one of and pasting all the values in the list.
No matter what I used, it is only allowing 4 values.
Am I doing something wrong?
Thanks,
Karen
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2017 10:23 AM
Yes, that will more easy to code and maintain. Add a field called category to map all the descriptions to different categories.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2017 03:06 PM
For what it's worth, you might find this helpful when dealing with building your advanced reference qualifier.
Video: Scripting Complex Queries Quickly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-10-2017 10:30 PM
Hi Karen,
One more approach is you can make your item description field as dependent which is OOB feature and then you can show the values in item description field dependent on category field.
If you want to make one field dependent on other field. We have very simple way to do in servicenow.
Hope this helps you.
Creating Dependent Reference Fields
http://wiki.servicenow.com/index.php?title=Adding_Dependent_Variables#gsc.tab=0
Mark answer correct if this helps you.
Regards,
Shamma