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?

[Ankur Bawiskar · Accepted solution]

Hi,

Should work fine

but try this as well -> are you sure the choice values are correct and those are not Choice labels.

javascript:'u_type=Data^ORu_type=Data Center';

regards
Ankur

[Jake Adams]

Hi, 

I used this advanced qualifier javascript:'u_type=Data^ORu_type=Data Center';

and then in the attributes I removed the tree_picker=true and it's working now, Is that a cause?

[Ankur Bawiskar]

Hi,

tree_picker might be an issue.

If you remove tree_picker and use this then it should still work fine

javascript:'u_typeINData,Data Center';

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards
Ankur