​
Example

{% if data="demo_daily_orders" %}
	Content
{% /if %}

​
Attributes

​
data
String
required
Table or view to query
​
filters
Array
default:"[]"
Array of column names to use as filters
​
condition
String
default:"has_rows"
Set to “no_rows” to render children only if the query returns no rows. Set to “has_rows” (or omit) to render if query returns rows.
​
where
String
Custom SQL WHERE condition to apply to the query. For date filters, use date_range instead.
​
having
String
Custom SQL HAVING condition to apply to the query after GROUP BY
​
limit
Number
Maximum number of rows to return from the query
​
order
String
Column name(s) with optional direction (e.g. “column_name”, “column_name desc”)
​
qualify
String
Custom SQL QUALIFY condition to filter windowed results