How to ads filter “is one of” to a field

[Alon Grod]

Is there any way to add the filter “is one of” to a reference field on the incident table?

[Shubham26]

Hi Alon,

Direct on reference field, "is one of" option is not available in filter but you can try with using show related fields and try with either number or sys id or any string type field of incident table.

[AndersBGS]

Hi @Alon Grod ,

Yep. In the condition you need to dot-walk. E.g. instead of:

Then you should go to name field:

Same goes for other reference fields.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

best regards

Anders 

[Pratima Kalamka]

Hello Alon Grod,

This filter give dotwalking.

Like this->

If my answer is helpful please mark it as helpful or correct!!

[Pratima Kalamka]

Hello @Alon Grod ,

Please try this ways:

1. Open the dictionary entry for the reference field.
2. Locate the "Reference Qualifier" field and add the encoded query that represents your "is one of" condition.
3. For example, if you want to filter the Caller field to only show users whose department is one of a predefined list of departments (e.g., HR, IT, Finance), you would construct the encoded query like this:

departmentINHR,IT,Finance (Here, IN is the operator for "is one of", and HR,IT,Finance is the list of departments you want to include.

If my answer is helpful please mark it as helpful or correct!!

Regards,

Pratima.k