How to enalble ""is not one of" operator in the fileter

Sagaya1 · ‎11-13-2020

Hi,

I need to run the filter with "is not one of" operator . But in servicenow instance i am unable to see it . Please help to enable it .

In the Sub category , i am unable to see the "is not one of " operator in the filter .

Regards

Sagaya

Ankur Bawiskar · ‎11-22-2020

@Sagaya

Thanks for marking my response as helpful.

I could see you marked my response as correct earlier and now it is not.

You can only choose 1 reply as correct.

Please mark the appropriate response as correct

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Hitoshi Ozawa · ‎11-13-2020

"is not one of" is only available in choice field type.

https://docs.servicenow.com/bundle/jakarta-servicenow-platform/page/use/common-ui-elements/reference...

For example, "Expenditure type" in asset (alm_asset).

FYI, choice fields are listed by viewing "sys_choice_set" table.

EDIT: In non-choice fields, use multiple "is not" conditions with "and".

Hitoshi Ozawa · ‎11-15-2020

@Sagaya Did you select the wrong reply? The practice in this forum is to select the first reply that answers the original question. The selected reply was posted after I've posted my reply and is only offers a different example from the one I've provided.