Reference qualifier not working for location field

[Jake Adams]

Hi,

I have a custom choice field 'Type' in the cmn_location table with choices as A, B, C and D. In the CMDB table I am using a reference field 'Location' which refers to cmn_location.

I have applied a simple reference qualifier as below:

Type is A or Type is C

But while click the magnifying glass in the 'Location' field it is only showing Type A records and not Type C. Am I missing something here?

[Community Alums]

Did you try Type A and Type C?

[Jake Adams]

Yes I tried that as well, but it didn't show any records at that time

[Ankur Bawiskar]

Hi,

try this advanced ref qualifier -> ensure you give correct field name and choice value and not choice label

javascript:'typeINA,C';

OR share what you tried?

Regards
Ankur

[Jake Adams]

Hi, 

Field name is u_type and choice values are Data and Data Center. I am using the below but still it shows only type related to Data

javascript:'u_typeINData,Data Center';