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.