Skip to main content
In SQL, this parameter allows the filters set in the outer query to be passed into the inner query.
If filters applied in the outer query aren’t being pushed into the SQL of the query view, check that the filtered field can be joined to the query view’s base view within the topic. Omni can only push filters into the query view when there is a valid join path. In some cases, filters also won’t be pushed down if the field is only accessible via an XLOOKUP rather than a join.

​
Limitations

Only supported for query views based on modeled workbook queries. If defining a SQL-based query view using the sql parameter, use a parameterized WHERE clause to achieve the same results.

​
Syntax

query:
  bind_all_filters: <true_or_false>

​
Properties

​
query
object[]
An object containing the individual parameters that make up a query view’s query definition.

​
Examples

When this query view is used, Omni will attempt to push all filters from the outer query into the query view’s SQL. Any filters whose fields can be joined to the query view’s base_view will be applied inside the query view. Filters that cannot be joined are not pushed down and remain applied in the outer query instead. 
query:
  fields:
    users.id: id
    order_items.sale_price_sum: sale_price_sum
  base_view: order_items
  sorts:
    - field: order_items.sale_price_sum
      desc: true
  topic: order_items
  bind_all_filters: true