Else If

Example

{% if data="demo_daily_orders" condition="no_rows" %}
	If Content
{% /if %}
{% else_if data="demo_daily_orders" %}
	Else If Content
{% /else_if %}

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