Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.omni.co/llms.txt

Use this file to discover all available pages before exploring further.

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