List Input Filter

A List Input Filter allows users to manually input a list of values into the queries.

Options#

  • Help text: Optional. Description of the filter.
  • Maximum number of items: Optional. This allows you to set a limit for the maximum number of items in a list input. If no input is given, it defaults to 5000 items.

How to use#

When adding a list input into your query, round brackets are added around the filter value ({{ids}}):

SELECT id, name, bookings
FROM customer_bookings
WHERE [[ id::VARCHAR IN ({{ids}}) ]]`

The generated query will look like this:

SELECT id, name, bookings
FROM customer_bookings
WHERE id::VARCHAR IN ('1', '2', '3', '4')`

To find out more about Holistic query syntax, please see Query Syntax References.