Is there a limit on the number of values for a reference qualifier

Cupcake
Mega Guru

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.

find_real_file.png

Am I doing something wrong?

Thanks,

Karen

1 ACCEPTED SOLUTION

Yes, that will more easy to code and maintain. Add a field called category to map all the descriptions to different categories.


View solution in original post

21 REPLIES 21

Chuck Tomasi
Tera Patron

For what it's worth, you might find this helpful when dealing with building your advanced reference qualifier.



Video: Scripting Complex Queries Quickly


Shamma Negi
Kilo Sage
Kilo Sage

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


Regards,Shamma Negi