where_sql

This parameter applies a filter condition to all rows in the query after the join has been performed. The clause does not pre-filter then join; it joins first and then uses the WHERE statement to filter the results.

Syntax

where_sql: <sql_filter_condition>

Properties

where_sql

string

A SQL condition that filters rows after the join is performed. Use ${view_name.field_name} syntax to reference fields.

Examples

Only include rows with order counts greater than 20

- join_from_view: users
  join_to_view: orders
  join_type: always_left
  on_sql: ${users.id} = ${orders.id}
  relationship_type: many_to_one
  where_sql: ${orders.count} < 20

reversible

Filter syntax

⌘I

Getting started

Manage content

Analyze & build

Visualize & present

Deliver content

Model data

Manage integrations

Syntax

Properties

Examples

​Syntax

​Properties

​Examples

Syntax

Properties

Examples