Simple Part Filtering

You can filter selection fields based on values stored in the underlying datastore. Any field in the datastore can be used for filtering.

For example, imagine a datastore called Filtering Examples, containing the following fields:

Field name	Description
Value	The actual selectable value (e.g. the name of a city).
Filter	A secondary field used for filtering (e.g. the country of the city).

Below is an example dataset in this datastore:

Value (City)	Filter (Country)
Bruges	Belgium
Brussels	Belgium
Ghent	Belgium
Putte	Belgium
Amsterdam	The Netherlands
Putte	The Netherlands
Rotterdam	The Netherlands
Frankfurt	Germany
Dresden	Germany

When entering a filter, set the Filter type to Plain text.

Filter examples

Show only cities from Belgium

[{ "fieldname": "Filter", "filtervalue": "Belgium" }]

Result: Brussels, Ghent, and Putte

Show cities from both Germany and Belgium

[
  { "fieldname": "Filter", "filtervalue": "Belgium" },
  { "connector": "or", "fieldname": "Filter", "filtervalue": "Germany" }
]

Result: Brussel, Ghent, Putte, Franktfurt and Dresden

Show cities from that are in Belgium and The Netherlands

[
  { "fieldname": "Filter", "filtervalue": "Belgium" },
  { "connector": "and", "fieldname": "Filter", "filtervalue": "The Netherlands" }
]

Result: Putte