---
url: "https://www.skedulo.com/release-notes/listview-filters-now-support-is-one-of-and-is-not-one-of-operators"
type: "releaseNote"
title: "ListView filters now support “is one of” and “is not one of” operators"
date: "2024-03-20"
---

# ListView filters now support “is one of” and “is not one of” operators

When creating filters for a list view, if the field being filtered is of type Lookup or Picklist, then users can apply new operators: “is one of” and “is not one of”. This allows users to compare multiple values in a single expression.

In List Views you can use the Filter options to restrict which data is displayed.

The operators you can choose from depend on the type of field you are attempting to filter by.

For Lookups, Picklist you could previously use the following operators:

- is
- is not

This change introduces new operators that expand the list to:

- is
- is not
- is one of
- is not one of

If you choose either “is one of” or “is not one of” you are presented with a multi-select control that allows you to search for, and select, multiple values.

**Replace “OR” queries in advanced mode for single field comparison** This is a meaningful improvement to filtering list views, as it allows a user to apply “OR” like conditions to their filters without having to use the advanced/Lucene filter query format.

For example, this Lucene query:

Status:Draft OR Status:Active

becomes possible in the UI with:

Where [Status] [is one of] [Draft, Active]

**Lucene syntax** There is equivalent support for these new operators in Lucene queries. The above example would be represented as:

Status:$in[“Draft”,”Active”]

Or for “is not one of”

-Status:$in[“Draft”,”Active”]

**Data source support** The operators that are available in list view filters depend on the underlying data source and which operations the data source supports. At present only the standard and custom objects, sourced via Skedulo GraphQL, support these new operators.

For more information, please refer to the documentation.