Missing condition operator "is not one of"

[reddy567]

Hi All,

Could anyone please tell me how to get/add a "is not one of" condition operator into the filter conditions for the tables. I see that condition operator is not listed for all the tables.

Thanks,

Kranti

[Anurag Tripathi]

I have added an idea on the idea portal for the same

https://community.servicenow.com/community?id=view_idea&sysparm_idea_id=5cdf20231bf54c90d01143f6fe4bcb6e&sysparm_idea_table=x_snc_com_ideation_idea&sysparm_module_id=enhancement_requests

[dshankula]

@Anurag Tripathi they closed out your idea so I went ahead and created a new one. This makes trying to filter out data you know is right/wrong from a list a pain.

https://community.servicenow.com/community?id=view_idea&sysparm_idea_id=c355af9b1b190110faf255fa234b...

[Hitoshi Ozawa]

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

To list Choice fields, open "sys_choice_set.list" from application navigator.

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

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

[Sigval Bergesen]

you may do an is one of or is not one of for any field type if you just modify the query in the url as explained above 😉 

[Community Alums]

Hi guys,

as Sigval said, it's totally possible by modifying the URL.

Replace 

https://...sysparm_query%3Dfield_nameINtext1,text2...

by

https://...sysparm_query%3Dfield_nameNOT%20INtext1,text2...

Regards

Christophe