> ## 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.

# bind_all_filters

> Passes all chosen filters from the outer query into the query view definition.

In SQL, this parameter allows the filters set in the outer query to be passed into the inner query.

<Tip>
  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.
</Tip>

## 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](/modeling/templated-filters/#parameterized-where-clause-in-views-based-on-a-sql-query) to achieve the same results.

## Syntax

```yaml theme={null}
query:
  bind_all_filters: <true_or_false>
```

## Properties

<ParamField path="query" type="object[]">
  An object containing the individual parameters that make up a query view's query definition.

  <Expandable title="query properties" defaultOpen="true">
    <ParamField path="bind_all_filters" type="boolean">
      If `true`, all filters from the outer query will be passed into the query view.
    </ParamField>
  </Expandable>
</ParamField>

## 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.

```yaml theme={null}
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
```