Parameter Types

There are several types of parameters, depending on the type of input form generated and the data type.

1. Text input (STRING):

Simple string input field.

  • Format:

    • Escaped as a string in SQL.

    • Ex: Converted to 'val1'

  • If empty:

    • ''

2. Text multi input (STRING[])

A field for entering multiple strings.

  • Format:

    • Escaped as a comma-separated string in SQL.

    • Ex: Converted to 'val1', 'val2'

  • If empty:

    • ''

3. Text select (STRING):

A dropdown to select a single string value.

  • Source options:

    • Fixed list or table values or query results.

  • Format:

    • Escaped as a string in SQL.

  • If empty:

    • ''

4. Text multi select (STRING[])

A dropdown for selecting multiple string values.

  • Source options:

    • Fixed list or table values or query results.

  • Format:

    • Escaped as a comma-separated string in SQL.

    • Ex: Converted to 'val1', 'val2'

  • If empty:

    • ''

5. Number input (NUMBER):

A simple numeric input field.

  • Options:

    • min, max, steps (intervals)

  • If empty:

    • 0

6. Number select (NUMBER):

A dropdown for selecting a single number.

  • Source options:

    • Fixed list or table values or query results.

  • If empty:

    • 0

7. Date input (DATE):

A simple date input field. Allows selection from a calendar or by entering a date.

  • Options:

    • Unit:

      • Date, Week, Month, Year

    • Start day of week (First day displayed in calendar):

      • Sun, Mon, Tue, Wed, Thu, Fri, Sat

    • Relative valid range:

      • Days before today: Dates earlier than this limit become unselectable. For example, entering '90' will make dates earlier than 90 days unselectable.

      • Days after today: Dates beyond this limit become unselectable. For example, entering 0 will make dates from the next day onwards unselectable, and entering -1 will make dates from today onwards unselectable.

    • Absolute valid range:

      • Lower date: Dates before this specified date become unselectable.

      • Upper date: Dates after this specified date become unselectable.

  • Format:

    • Expanded in yyyy-MM-dd format as a string in SQL.

    • Ex: Converted to '2024-01-01'

8. Date range ([DATE, DATE]) :

Specifies a start and end date as a pair.

  • Options:

    • Identical to those for Date Input (DATE)

  • Syntax for SQL reference:

    • Start Date: {{param_name}}.StartDate

    • End Date: {{param_name}}.EndDate

9. Checkbox (BOOLEAN):

Simple Boolean checkbox.

  • Format:

    • Expanded as true or false in SQL.

Last updated

Was this helpful?