> ## Documentation Index
> Fetch the complete documentation index at: https://developers.notion.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Filter database entries

<Danger>
  **Deprecated as of version 2025-09-03**

  This page describes the API for versions up to and including `2022-06-28`. In the new `2025-09-03` version, the concepts of databases and data sources were split up, as described in [Upgrading to 2025-09-03](/guides/get-started/upgrade-guide-2025-09-03).

  Refer to the new page instead:

  * [Filter data source entries](/reference/filter-data-source-entries)
</Danger>

When you [query a database](/reference/post-database-query), you can send a `filter` object in the body of the request that limits the returned entries based on the specified criteria.

For example, the below query limits the response to entries where the `"Task completed"` `checkbox` property value is `true`:

<CodeGroup>
  ```curl cURL theme={null}
  curl -X POST 'https://api.notion.com/v1/databases/897e5a76ae524b489fdfe71f5945d1af/query' \
    -H 'Authorization: Bearer '"$NOTION_API_KEY"'' \
    -H 'Notion-Version: 2022-06-28' \
    -H "Content-Type: application/json" \
  --data '{
    "filter": {
      "property": "Task completed",
      "checkbox": {
          "equals": true
     }
    }
  }'
  ```

  ```javascript JavaScript theme={null}
  const { Client } = require('@notionhq/client');

  const notion = new Client({ auth: process.env.NOTION_API_KEY });
  // replace with your own database ID
  const databaseId = 'd9824bdc-8445-4327-be8b-5b47500af6ce';

  const filteredRows = async () => {
  	const response = await notion.databases.query({
  	  database_id: databaseId,
  	  filter: {
  	    property: "Task completed",
  	    checkbox: {
  	      equals: true
  	    }
  	  },
  	});
    return response;
  }
  ```
</CodeGroup>

Filters can be chained with the `and` and `or` keys so that multiple filters are applied at the same time. (See [Query a database](/reference/post-database-query) for additional examples.)

<CodeGroup>
  ```json JSON theme={null}
  {
    "and": [
      {
        "property": "Done",
        "checkbox": {
          "equals": true
        }
      },
      {
        "or": [
          {
            "property": "Tags",
            "contains": "A"
          },
          {
            "property": "Tags",
            "contains": "B"
          }
        ]
      }
    ]
  }
  ```
</CodeGroup>

If no filter is provided, non-archived pages in the database will be returned with pagination.

## The filter object

Each `filter` object contains the following fields:

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `property` | `string` | The name of the property as it appears in the database, or the property ID. | `"Task completed"` |
| `checkbox`<br />`date`<br />`files`<br />`formula`<br />`multi_select`<br />`number`<br />`people`<br />`phone_number`<br />`relation`<br />`rich_text`<br />`select`<br />`status`<br />`timestamp`<br />`verification`<br />`ID` | `object` | The type-specific filter condition for the query. Only types listed in the Field column of this table are supported. <br /> <br /> Refer to [type-specific filter conditions](#type-specific-filter-conditions) for details on corresponding object values. | `"checkbox": { "equals": true }` |

<CodeGroup>
  ```json Example checkbox filter object theme={null}
  {
    "filter": {
      "property": "Task completed",
      "checkbox": {
        "equals": true
      }
    }
  }
  ```
</CodeGroup>

<Check>
  The filter object mimics the database [filter option in the Notion UI](https://www.notion.com/help/views-filters-and-sorts).
</Check>

## Type-specific filter conditions

### Checkbox

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `equals` | `boolean` | Whether a `checkbox` property value matches the provided value exactly. <br /> <br /> Returns or excludes all database entries with an exact value match. | `false` |
| `does_not_equal` | `boolean` | Whether a `checkbox` property value differs from the provided value. <br /> <br /> Returns or excludes all database entries with a difference in values. | `true` |

<CodeGroup>
  ```json Example checkbox filter condition theme={null}
  {
    "filter": {
      "property": "Task completed",
      "checkbox": {
        "does_not_equal": true
      }
    }
  }
  ```
</CodeGroup>

### Date

<Note>
  For the `after`, `before`, `equals, on_or_before`, and `on_or_after` fields, if a date string with a time is provided, then the comparison is done with millisecond precision.

  If no timezone is provided, then the timezone defaults to UTC.
</Note>

A date filter condition can be used to limit `date` property value types and the [timestamp](#timestamp) property types `created_time` and `last_edited_time`.

The condition contains the below fields:

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `after` | `string` ([ISO 8601 date](https://en.wikipedia.org/wiki/ISO_8601) or [relative date](#relative-date-values)) | The value to compare the date property value against. <br /> <br /> Returns database entries where the date property value is after the provided date. | `"2021-05-10"` `"yesterday"` |
| `before` | `string` ([ISO 8601 date](https://en.wikipedia.org/wiki/ISO_8601) or [relative date](#relative-date-values)) | The value to compare the date property value against. <br /> <br /> Returns database entries where the date property value is before the provided date. | `"2021-05-10"` `"tomorrow"` |
| `equals` | `string` ([ISO 8601 date](https://en.wikipedia.org/wiki/ISO_8601) or [relative date](#relative-date-values)) | The value to compare the date property value against. <br /> <br /> Returns database entries where the date property value is the provided date. | `"2021-05-10"` `"today"` |
| `is_empty` | `true` | The value to compare the date property value against. Returns database entries where the date property value contains no data. | `true` |
| `is_not_empty` | `true` | The value to compare the date property value against. Returns database entries where the date property value is not empty. | `true` |
| `next_month` | `object` (empty) | A filter that limits the results to database entries where the date property value is within the next month. | `{}` |
| `next_week` | `object` (empty) | A filter that limits the results to database entries where the date property value is within the next week. | `{}` |
| `next_year` | `object` (empty) | A filter that limits the results to database entries where the date property value is within the next year. | `{}` |
| `on_or_after` | `string` ([ISO 8601 date](https://en.wikipedia.org/wiki/ISO_8601) or [relative date](#relative-date-values)) | The value to compare the date property value against. <br /> <br /> Returns database entries where the date property value is on or after the provided date. | `"2021-05-10"` `"today"` |
| `on_or_before` | `string` ([ISO 8601 date](https://en.wikipedia.org/wiki/ISO_8601) or [relative date](#relative-date-values)) | The value to compare the date property value against. <br /> <br /> Returns database entries where the date property value is on or before the provided date. | `"2021-05-10"` `"today"` |
| `past_month` | `object` (empty) | A filter that limits the results to database entries where the `date` property value is within the past month. | `{}` |
| `past_week` | `object` (empty) | A filter that limits the results to database entries where the `date` property value is within the past week. | `{}` |
| `past_year` | `object` (empty) | A filter that limits the results to database entries where the `date` property value is within the past year. | `{}` |
| `this_week` | `object` (empty) | A filter that limits the results to database entries where the `date` property value is this week. | `{}` |

#### Relative date values

The `after`, `before`, `equals`, `on_or_after`, and `on_or_before` fields accept the following relative date strings in addition to ISO 8601 dates. These are resolved at query time:

| Value | Description |
| :- | :- |
| `"today"` | The current date. |
| `"tomorrow"` | The day after the current date. |
| `"yesterday"` | The day before the current date. |
| `"one_week_ago"` | Seven days before the current date. |
| `"one_week_from_now"` | Seven days after the current date. |
| `"one_month_ago"` | One month before the current date. |
| `"one_month_from_now"` | One month after the current date. |

<CodeGroup>
  ```json Example date filter condition theme={null}
  {
    "filter": {
      "property": "Due date",
      "date": {
        "on_or_after": "2023-02-08"
      }
    }
  }
  ```

  ```json Example relative date filter condition theme={null}
  {
    "filter": {
      "property": "Due date",
      "date": {
        "on_or_after": "today"
      }
    }
  }
  ```
</CodeGroup>

### Files

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `is_empty` | `true` | Whether the files property value does not contain any data. <br /> <br /> Returns all database entries with an empty `files` property value. | `true` |
| `is_not_empty` | `true` | Whether the `files` property value contains data. <br /> <br /> Returns all entries with a populated `files` property value. | `true` |

<CodeGroup>
  ```json Example files filter condition theme={null}
  {
    "filter": {
      "property": "Blueprint",
      "files": {
        "is_not_empty": true
      }
    }
  }
  ```
</CodeGroup>

### Formula

The primary field of the `formula` filter condition object matches the type of the formula’s result. For example, to filter a formula property that computes a `checkbox`, use a `formula` filter condition object with a `checkbox` field containing a checkbox filter condition as its value.

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `checkbox` | `object` | A [checkbox](#checkbox) filter condition to compare the formula result against. <br /> <br /> Returns database entries where the formula result matches the provided condition. | Refer to the [checkbox](#checkbox) filter condition. |
| `date` | `object` | A [date](#date) filter condition to compare the formula result against. <br /> <br /> Returns database entries where the formula result matches the provided condition. | Refer to the [date](#date) filter condition. |
| `number` | `object` | A [number](#number) filter condition to compare the formula result against. <br /> <br /> Returns database entries where the formula result matches the provided condition. | Refer to the [number](#number) filter condition. |
| `string` | `object` | A [rich text](#rich-text) filter condition to compare the formula result against. <br /> <br /> Returns database entries where the formula result matches the provided condition. | Refer to the [rich text](#rich-text) filter condition. |

<CodeGroup>
  ```json Example formula filter condition theme={null}
  {
    "filter": {
      "property": "One month deadline",
      "formula": {
        "date":{
            "after": "2021-05-10"
        }
      }
    }
  }
  ```
</CodeGroup>

### Multi-select

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `contains` | `string` or `string[]` | The value(s) to compare the multi-select property value against. <br /> <br /> Returns database entries where the multi-select value matches any of the provided values. | `"Marketing"` or `["Marketing", "Sales"]` |
| `does_not_contain` | `string` or `string[]` | The value(s) to compare the multi-select property value against. <br /> <br /> Returns database entries where the multi-select value does not match any of the provided values. | `"Engineering"` or `["Engineering", "QA"]` |
| `is_empty` | `true` | Whether the multi-select property value is empty. <br /> <br /> Returns database entries where the multi-select value does not contain any data. | `true` |
| `is_not_empty` | `true` | Whether the multi-select property value is not empty. <br /> <br /> Returns database entries where the multi-select value does contains data. | `true` |

<CodeGroup>
  ```json Example multi-select filter condition theme={null}
  {
    "filter": {
      "property": "Programming language",
      "multi_select": {
        "contains": "TypeScript"
      }
    }
  }
  ```
</CodeGroup>

### Number

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `does_not_equal` | `number` | The `number` to compare the number property value against. <br /> <br /> Returns database entries where the number property value differs from the provided `number`. | `42` |
| `equals` | `number` | The `number` to compare the number property value against. <br /> <br /> Returns database entries where the number property value is the same as the provided number. | `42` |
| `greater_than` | `number` | The `number` to compare the number property value against. <br /> <br /> Returns database entries where the number property value exceeds the provided `number`. | `42` |
| `greater_than_or_equal_to` | `number` | The `number` to compare the number property value against. <br /> <br /> Returns database entries where the number property value is equal to or exceeds the provided `number`. | `42` |
| `is_empty` | `true` | Whether the `number` property value is empty. <br /> <br /> Returns database entries where the number property value does not contain any data. | `true` |
| `is_not_empty` | `true` | Whether the number property value is not empty. <br /> <br /> Returns database entries where the number property value contains data. | `true` |
| `less_than` | `number` | The `number` to compare the number property value against. <br /> <br /> Returns database entries where the number property value is less than the provided `number`. | `42` |
| `less_than_or_equal_to` | `number` | The `number` to compare the number property value against. <br /> <br /> Returns database entries where the number property value is equal to or is less than the provided `number`. | `42` |

<CodeGroup>
  ```json Example number filter condition theme={null}
  {
    "filter": {
      "property": "Estimated working days",
      "number": {
        "less_than_or_equal_to": 5
      }
    }
  }
  ```
</CodeGroup>

### People

You can apply a people filter condition to `people`, `created_by`, and `last_edited_by` database property types.

The people filter condition contains the following fields:

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `contains` | `string` (UUIDv4) or `"me"` | The value to compare the people property value against. <br /> <br /> Returns database entries where the people property value contains the provided user. Pass a user UUID or `"me"` to match the current user (see note below). | `"6c574cee-ca68-41c8-86e0-1b9e992689fb"` |
| `does_not_contain` | `string` (UUIDv4) or `"me"` | The value to compare the people property value against. Returns database entries where the people property value does not contain the provided user. Pass a user UUID or `"me"` to match the current user (see note below). | `"6c574cee-ca68-41c8-86e0-1b9e992689fb"` |
| `is_empty` | `true` | Whether the people property value does not contain any data. <br /> <br /> Returns database entries where the people property value does not contain any data. | `true` |
| `is_not_empty` | `true` | Whether the people property value contains data. <br /> <br /> Returns database entries where the people property value is not empty. | `true` |

<CodeGroup>
  ```json Example people filter condition theme={null}
  {
    "filter": {
      "property": "Last edited by",
      "people": {
        "contains": "c2f20311-9e54-4d11-8c79-7398424ae41e"
      }
    }
  }
  ```

  ```json Example "me" filter condition theme={null}
  {
    "filter": {
      "property": "Assignee",
      "people": {
        "contains": "me"
      }
    }
  }
  ```
</CodeGroup>

<Note>
  The `"me"` value resolves to the user associated with the token. For [public connections](/guides/get-started/overview#connection-types), this is the user who completed the OAuth flow. For [personal access tokens](/guides/get-started/personal-access-tokens), this is the user who created the token. For [internal connections](/guides/get-started/overview#connection-types), there is no associated user — `contains: "me"` returns no results and `does_not_contain: "me"` matches all entries.
</Note>

### Relation

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `contains` | `string` (UUIDv4) | The value to compare the relation property value against. <br /> <br /> Returns database entries where the relation property value contains the provided `string`. | `"6c574cee-ca68-41c8-86e0-1b9e992689fb"` |
| `does_not_contain` | `string` (UUIDv4) | The value to compare the relation property value against. <br /> <br /> Returns entries where the relation property value does not contain the provided `string`. | `"6c574cee-ca68-41c8-86e0-1b9e992689fb"` |
| `is_empty` | `true` | Whether the relation property value does not contain data. <br /> <br /> Returns database entries where the relation property value does not contain any data. | `true` |
| `is_not_empty` | `true` | Whether the relation property value contains data. <br /> <br /> Returns database entries where the property value is not empty. | `true` |

<CodeGroup>
  ```json Example relation filter condition theme={null}
  {
    "filter": {
      "property": "✔️ Task List",
      "relation": {
        "contains": "0c1f7cb280904f18924ed92965055e32"
      }
    }
  }
  ```
</CodeGroup>

### Rich text

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `contains` | `string` | The `string` to compare the text property value against. <br /> <br /> Returns database entries with a text property value that includes the provided `string`. | `"Moved to Q2"` |
| `does_not_contain` | `string` | The `string` to compare the text property value against. <br /> <br /> Returns database entries with a text property value that does not include the provided `string`. | `"Moved to Q2"` |
| `does_not_equal` | `string` | The `string` to compare the text property value against. <br /> <br /> Returns database entries with a text property value that does not match the provided `string`. | `"Moved to Q2"` |
| `ends_with` | `string` | The `string` to compare the text property value against. <br /> <br /> Returns database entries with a text property value that ends with the provided `string`. | `"Q2"` |
| `equals` | `string` | The `string` to compare the text property value against. <br /> <br /> Returns database entries with a text property value that matches the provided `string`. | `"Moved to Q2"` |
| `is_empty` | `true` | Whether the text property value does not contain any data. <br /> <br /> Returns database entries with a text property value that is empty. | `true` |
| `is_not_empty` | `true` | Whether the text property value contains any data. <br /> <br /> Returns database entries with a text property value that contains data. | `true` |
| `starts_with` | `string` | The `string` to compare the text property value against. <br /> <br /> Returns database entries with a text property value that starts with the provided `string`. | "Moved" |

<CodeGroup>
  ```json Example rich text filter condition theme={null}
  {
    "filter": {
      "property": "Description",
      "rich_text": {
        "contains": "cross-team"
      }
    }
  }
  ```
</CodeGroup>

### Rollup

A rollup database property can evaluate to an array, date, or number value. The filter condition for the rollup property contains a `rollup` key and a corresponding object value that depends on the computed value type.

#### Filter conditions for `array` rollup values

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `any` | `object` | The value to compare each rollup property value against. Can be a [filter condition](#type-specific-filter-conditions) for any other type. <br /> <br /> Returns database entries where the rollup property value matches the provided criteria. | `"rich_text": { "contains": "Take Fig on a walk" }` |
| `every` | `object` | The value to compare each rollup property value against. Can be a [filter condition](#type-specific-filter-conditions) for any other type. <br /> <br /> Returns database entries where every rollup property value matches the provided criteria. | `"rich_text": { "contains": "Take Fig on a walk" }` |
| `none` | `object` | The value to compare each rollup property value against. Can be a [filter condition](#type-specific-filter-conditions) for any other type. <br /> <br /> Returns database entries where no rollup property value matches the provided criteria. | `"rich_text": { "contains": "Take Fig on a walk" }` |

<CodeGroup>
  ```json Example array rollup filter condition theme={null}
  {
    "filter": {
      "property": "Related tasks",
      "rollup": {
        "any": {
          "rich_text": {
            "contains": "Migrate database"
          }
        }
      }
    }
  }
  ```
</CodeGroup>

#### Filter conditions for `date` rollup values

A rollup value is stored as a `date` only if the "Earliest date", "Latest date", or "Date range" computation is selected for the property in the Notion UI.

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `date` | `object` | A [date](#date) filter condition to compare the rollup value against. <br /> <br /> Returns database entries where the rollup value matches the provided condition. | Refer to the [date](#date) filter condition. |

<CodeGroup>
  ```json Example date rollup filter condition theme={null}
  {
    "filter": {
      "property": "Parent project due date",
      "rollup": {
        "date": {
          "on_or_before": "2023-02-08"
        }
      }
    }
  }
  ```
</CodeGroup>

#### Filter conditions for `number` rollup values

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `number` | `object` | A [number](#number) filter condition to compare the rollup value against. <br /> <br /> Returns database entries where the rollup value matches the provided condition. | Refer to the [number](#number) filter condition. |

<CodeGroup>
  ```json Example number rollup filter condition theme={null}
  {
    "filter": {
      "property": "Total estimated working days",
      "rollup": {
        "number": {
          "does_not_equal": 42
        }
      }
    }
  }
  ```
</CodeGroup>

### Select

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `equals` | `string` or `string[]` | The value(s) to compare the select property value against. <br /> <br /> Returns database entries where the select property value matches any of the provided values. | `"This week"` or `["Low", "Medium"]` |
| `does_not_equal` | `string` or `string[]` | The value(s) to compare the select property value against. <br /> <br /> Returns database entries where the select property value does not match any of the provided values. | `"Backlog"` or `["Done", "Archive"]` |
| `is_empty` | `true` | Whether the select property value does not contain data. <br /> <br /> Returns database entries where the select property value is empty. | `true` |
| `is_not_empty` | `true` | Whether the select property value contains data. <br /> <br /> Returns database entries where the select property value is not empty. | `true` |

<CodeGroup>
  ```json Example select filter condition theme={null}
  {
    "filter": {
      "property": "Frontend framework",
      "select": {
        "equals": "React"
      }
    }
  }
  ```
</CodeGroup>

### Status

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| equals | string or string\[] | The value(s) to compare the status property value against. <br /> <br /> Returns database entries where the status property value matches any of the provided values. Status group names (e.g. "To-do", "In progress", "Complete") are also accepted. | "This week" or \["To-do", "In progress"] |
| does\_not\_equal | string or string\[] | The value(s) to compare the status property value against. <br /> <br /> Returns database entries where the status property value does not match any of the provided values. | "Backlog" or \["Done", "Archive"] |
| is\_empty | true | Whether the status property value does not contain data. <br /> <br /> Returns database entries where the status property value is empty. | true |
| is\_not\_empty | true | Whether the status property value contains data. <br /> <br /> Returns database entries where the status property value is not empty. | true |

<CodeGroup>
  ```json Example status filter condition theme={null}
  {
    "filter": {
      "property": "Project status",
      "status": {
        "equals": "Not started"
      }
    }
  }
  ```
</CodeGroup>

### Timestamp

Use a timestamp filter condition to filter results based on `created_time` or `last_edited_time` values.

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| timestamp | created\_time last\_edited\_time | A constant string representing the type of timestamp to use as a filter. | "created\_time" |
| created\_time last\_edited\_time | object | A date filter condition used to filter the specified timestamp. | Refer to the [date](#date) filter condition. |

<CodeGroup>
  ```json Example timestamp filter condition for created_time theme={null}
  {
    "filter": {
      "timestamp": "created_time",
      "created_time": {
        "on_or_before": "2022-10-13"
      }
    }
  }
  ```
</CodeGroup>

<Warning>
  The `timestamp` filter condition does not require a property name. The API throws an error if you provide one.
</Warning>

### Verification

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `status` | string | Returns entries whose verification status matches the value. | `"verified"` |
| `does_not_equal` | string | Returns entries whose verification status does not match the value. | `"expired"` |

Both fields accept `verified`, `expired`, or `none`.

<CodeGroup>
  ```json Example verification filter condition for getting verified pages theme={null}
  {
    "filter": {
      "property": "verification",
      "verification": {
        "status": "verified"
      }
    }
  }
  ```
</CodeGroup>

### ID

Use a timestamp filter condition to filter results based on the `unique_id` value.

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `does_not_equal` | `number` | The value to compare the unique\_id property value against. <br /> <br /> Returns database entries where the unique\_id property value differs from the provided value. | `42` |
| `equals` | `number` | The value to compare the unique\_id property value against. <br /> <br /> Returns database entries where the unique\_id property value is the same as the provided value. | `42` |
| `greater_than` | `number` | The value to compare the unique\_id property value against. <br /> <br /> Returns database entries where the unique\_id property value exceeds the provided value. | `42` |
| `greater_than_or_equal_to` | `number` | The value to compare the unique\_id property value against. <br /> <br /> Returns database entries where the unique\_id property value is equal to or exceeds the provided value. | `42` |
| `less_than` | `number` | The value to compare the unique\_id property value against. <br /> <br /> Returns database entries where the unique\_id property value is less than the provided value. | `42` |
| `less_than_or_equal_to` | `number` | The value to compare the unique\_id property value against. <br /> <br /> Returns database entries where the unique\_id property value is equal to or is less than the provided value. | `42` |

<CodeGroup>
  ```json Example ID filter condition theme={null}
  {
    "filter": {
      "and": [
        {
          "property": "ID",
          "unique_id": {
            "greater_than": 1
          }
        },
        {
          "property": "ID",
          "unique_id": {
            "less_than": 3
          }
        }
      ]
    }
  }
  ```
</CodeGroup>

## Compound filter conditions

You can use a compound filter condition to limit the results of a database query based on multiple conditions. This mimics filter chaining in the Notion UI.

<Frame caption="An example filter chain in the Notion UI">
  <img src="https://mintcdn.com/notion-demo/kSI9TVzPayvF1_1o/images/reference/14ec7e8-Untitled.png?fit=max&auto=format&n=kSI9TVzPayvF1_1o&q=85&s=f7a7a738dcd526d2c1180c7f479fda31" width="1340" height="550" data-path="images/reference/14ec7e8-Untitled.png" />
</Frame>

The above filters in the Notion UI are equivalent to the following compound filter condition via the API:

<CodeGroup>
  ```json JSON theme={null}
  {
    "and": [
      {
        "property": "Done",
        "checkbox": {
          "equals": true
        }
      },
      {
        "or": [
          {
            "property": "Tags",
            "contains": "A"
          },
          {
            "property": "Tags",
            "contains": "B"
          }
        ]
      }
    ]
  }
  ```
</CodeGroup>

A compound filter condition contains an `and` or `or` key with a value that is an array of filter objects or nested compound filter objects. Nesting is supported up to two levels deep.

| Field | Type | Description | Example value |
| :- | :- | :- | :- |
| `and` | `array` | An array of [filter](#type-specific-filter-conditions) objects or compound filter conditions. <br /> <br /> Returns database entries that match **all** of the provided filter conditions. | Refer to the examples below. |
| or | array | An array of [filter](#type-specific-filter-conditions) objects or compound filter conditions. <br /> <br /> Returns database entries that match **any** of the provided filter conditions | Refer to the examples below. |

### Example compound filter conditions

<CodeGroup>
  ```json Example compound filter condition for a checkbox and number property value theme={null}
  {
    "filter": {
      "and": [
        {
          "property": "Complete",
          "checkbox": {
            "equals": true
          }
        },
        {
          "property": "Working days",
          "number": {
            "greater_than": 10
          }
        }
      ]
    }
  }
  ```
</CodeGroup>

<CodeGroup>
  ```json Example nested filter condition theme={null}
  {
    "filter": {
      "or": [
        {
          "property": "Description",
          "rich_text": {
            "contains": "2023"
          }
        },
        {
          "and": [
            {
              "property": "Department",
              "select": {
                "equals": "Engineering"
              }
            },
            {
              "property": "Priority goal",
              "checkbox": {
                "equals": true
              }
            }
          ]
        }
      ]
    }
  }
  ```
</CodeGroup>