where_sql - Relationships - Omni Docs

Adds a WHERE clause to the generated SQL when a join is established, applying a filter condition to all rows in the query after the join has been performed. The clause does not pre-filter and then join; it joins first and then uses the WHERE statement to filter the results.

Syntax

where_sql: <sql_filter_condition>

Properties

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 less 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

⌘I