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

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


Thank you I will update the table and include a field called category. So should if there are 5 descriptions that use the same category then I should have that category name for each description. Is that correct?


Abhinay Erra
Giga Sage

Yes that is correct.


Thank you again. So I've updated the table to include the category field, Should I control it using the Simple Reference Qualifier or will i still need to use the Advanced with scripting.


So what are the field types of category on the reference table and variable type of category on the item?