Types and data types

Parameters are classified by their input form type and data type.

Parameter list and zero values

The list of parameter types, their data types, and the zero value expanded into SQL when a value is unset, are as follows. Multi-input / multi-select types are arrays, but their zero value expands as an empty string ''.

Type	Type	Zero value
Text input	STRING	''
Text select	STRING	''
Text multi input	STRING[]	''
Text multi select	STRING[]	''
Number input	NUMBER	0
Number select	NUMBER	0
Date input	DATE	'1970-01-01'
Date range	[DATE, DATE]	Both start and end are '1970-01-01'
Checkbox	BOOLEAN	false

See Usage patterns in SQL for how to use the zero value to write an optional filter.

Common settings

In addition to type-specific settings, many parameters support the following.

Item	Description
Description	Shown as a tooltip next to the parameter name.
Placeholder	The placeholder text shown in the input form.

Text input

A field for entering a single string.

• Expanded in SQL as an escaped string (for example: 'val1').
• The zero value is ''.

Text multi input

A field for entering multiple strings.

• Expanded in SQL as a comma-separated, escaped string (for example: 'val1', 'val2').
• The zero value is ''.

Text select

A dropdown for choosing a single string from candidates.

• See Generating dynamic options for how candidates are generated.
• Expanded in SQL as an escaped string.
• The zero value is ''.

Text multi select

A dropdown for choosing multiple strings from candidates.

• See Generating dynamic options for how candidates are generated.
• Expanded in SQL as a comma-separated, escaped string (for example: 'val1', 'val2').
• The zero value is ''.
• You can select up to 1,000 values (see Limits).

Number input

A field for entering a single number.

Item	Description
Min	The lower bound of the input value.
Max	The upper bound of the input value.
Step	The increment step for input.

• Expanded in SQL as a number.
• The zero value is 0.

Number select

A dropdown for choosing a single number from candidates.

• See Generating dynamic options for how candidates are generated.
• The zero value is 0.

Date input

A field for choosing a single date. You can select from a calendar or enter the date directly.

Settings

Item	Description
Unit	Day / Week / Month / Year. Day if unspecified.
Unit reference point	When Unit is week, month, or year, chooses whether the value is normalized to the start or end of the period. Start if unspecified. The label changes based on the unit, such as Start of week / End of week.
Start of week	When Unit is day or week, chooses the day of the week used as the week boundary. Sunday if unspecified.
Relative valid range	Restricts the selectable range of past/future days relative to today.
Absolute valid range	Restricts the selectable range using a lower and upper bound date.

The breakdown of Relative valid range is as follows.

Item	Description
Days before today	Dates before this many days can't be selected. Example: entering 90 disallows dates more than 90 days in the past.
Days after today	Dates after this many days can't be selected. Example: 0 disallows tomorrow and later; -1 disallows today and later.

The breakdown of Absolute valid range is as follows.

Item	Description
Lower bound date	Dates before this date can't be selected.
Upper bound date	Dates after this date can't be selected.

Expansion

• Expanded in SQL as a string in YYYY-MM-DD format (for example: '2024-01-01').
• The zero value is '1970-01-01'.
• The default value can be set to a relative date.

If Unit is week, month, or year, the selected value is normalized to the start or end of the period according to unit anchor. For example, with unit "week," anchor "start," and start of week "Monday," the value becomes that week's Monday.

Date range

Specifies a start date and end date as a pair. The settings are the same as date input, except unit anchor isn't shown for date range; the start date is always normalized to the start of the period, and the end date to the end of the period.

For example, if Unit is Month and you select April–May 2026, the value becomes ["2026-04-01", "2026-05-31"].

Referencing this in SQL differs from the notation of other types; the start and end dates are specified separately.

• Start date: {label}.StartDate
• End date: {label}.EndDate

The zero value for both start and end dates is '1970-01-01'. The default value can be set to a relative date.

Checkbox

A checkbox for toggling a boolean value.

• Expanded in SQL as true or false.
• The zero value is false.