Variable Usage

Intelligent Apps support dynamic query generation using variables and Jinja-style templating. This allows you to build flexible dashboards that respond to user input from filters and variables.

​

Basic Variable Substitution

You can reference variables in your SQL queries using double curly braces:

query: |
  SELECT * FROM sales_orders WHERE order_date > '{{ order_date }}'

​

Conditional Query Blocks

You can use Jinja-style control structures to include or exclude parts of your query based on variable values:

query: |
  SELECT * FROM sales_orders
  WHERE 1=1
  {% if product_group != '' %}
    AND product_group = '{{ product_group }}'
  {% endif %}
  {% if membership_type != 'all' %}
    AND membership_type = '{{ membership_type }}'
  {% endif %}

​

Using Multiple Variables

Combine several variables for more complex filtering:

query: |
  SELECT * FROM sales_orders
  WHERE order_date BETWEEN '{{ start_date }}' AND '{{ end_date }}'
    AND amount > {{ min_amount }}

​

Example: Dynamic LIMIT

You can use variables to control query limits:

query: |
  SELECT * FROM sales_orders
  LIMIT {{ row_limit }}

​

Example: IN Clauses with Lists

If your variable is a list, you can use Jinja to join values for an IN clause:

query: |
  SELECT * FROM sales_orders
  WHERE region IN ({{ regions | join(", ") }})

​

Best Practices

• Always provide sensible defaults for variables to avoid empty queries.
• Use {% if ... %} blocks to prevent SQL errors when variables are empty or unset.
• Sanitize and validate user input where possible.

​

Reference: Jinja Syntax

• {{ variable }}: Insert variable value
• {% if ... %} ... {% endif %}: Conditional blocks
• {% for ... %} ... {% endfor %}: Loops (for advanced use)
• Filters like | join(", ") for lists

See also: Filters, Overview, Charts