'Is one of' filter to use in reference field

[mcarriedo]

Hi,

Is there a way to use a filter query similar to 'is one of' for reference field.   'Is one of' is not available for reference field.   I know you can use

'OR'   operator but if we're talking about 100 values, this could be a bit tedious.

Thanks.

[snehabinani26]

Hi Maria,

You can go ahead with Advanced Reference Qualifier.

Reference Qualifiers - ServiceNow Wiki

Hope this helps you.

[BALAJI40 · Accepted solution]

Hi Maria,

Is one of not available to reference field conditions. But you can use this for reference related Fields.

Here group name reference, so i tried to get the name and apply the is one of filter condition.

[mcarriedo]

Oh I forgot about the dotwalking.   Thanks for that.

[Constantine Kr1]

The list/filter UI will not provide the option by default. Use the following URL as an example (This uses the Out Of Box categories reference field on the catalog item table of a PDI (Personal Dev Instance)):

Example URL: 

https://<<INSTANCE NAME>>.service-now.com/sc_cat_item_list.do?sysparm_query=categoryIN2809952237b1300054b6a3549dbe5dd4%2C5d643c6a3771300054b6a3549dbe5db0&sysparm_view=

Using this URL, you will now see the drop down "IN". The sys_id is pasted into the field and is comma separated.

Alternatively, you can build out the URL in notepad. Each sys_id needs to be separated by a comma "," which gets translated into %2C in the URL (Reference: URL Encoding)

2809952237b1300054b6a3549dbe5dd4 - Category (Software)
5d643c6a3771300054b6a3549dbe5db0 - Category (Printers)

2809952237b1300054b6a3549dbe5dd4,5d643c6a3771300054b6a3549dbe5db0 

would convert into: 

https://<<INSTANCE NAME>>.service-now.com/sc_cat_item_list.do?sysparm_query=categoryIN2809952237b1300054b6a3549dbe5dd4%2C5d643c6a3771300054b6a3549dbe5db0&sysparm_view=