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

<AgentInstructions>

## Submitting Feedback

If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback:

POST https://docs.omni.co/feedback

```json
{
  "path": "/modeling/filters/operators/index",
  "feedback": "Description of the issue"
}
```

Only submit feedback when you have something specific and actionable to report.

</AgentInstructions>

# Filter operators

> Reference for all Omni model filter operators, including conditional, date, number, text, and advanced cross-query operators.

## Conditional

| Name                                     | Description                                                    |
| ---------------------------------------- | -------------------------------------------------------------- |
| [`and`](/modeling/filters/operators/and) | Returns rows that meet all specified conditions.               |
| [`or`](/modeling/filters/operators/or)   | Returns rows that meet at least one of the specified criteria. |
| [`is`](/modeling/filters/operators/is)   | Returns rows that exactly match the specified value.           |
| [`not`](/modeling/filters/operators/not) | Returns rows that do not match the specified value.            |

## Advanced

| Name                                                                             | Description                                                                                                          |
| -------------------------------------------------------------------------------- | -------------------------------------------------------------------------------------------------------------------- |
| [`cancel_query_filter`](/modeling/filters/operators/cancel-query-filter)         | Creates a measure that ignores the value of a filter in the user query in favor of the filter on the measure itself. |
| [`field_name_in_query`](/modeling/filters/operators/field-name-in-query)         | Filters a query using the results of another query, including only the rows present in the filtering query.          |
| [`field_name_not_in_query`](/modeling/filters/operators/field-name-not-in-query) | Filters a query using the results of another query, including only the rows **not** present in the filtering query.  |

## Date and time

| Name                                                                           | Description                                                                             |
| ------------------------------------------------------------------------------ | --------------------------------------------------------------------------------------- |
| [`before`](/modeling/filters/operators/before)                                 | Filters time fields for dates before a specified date.                                  |
| [`between_dates`](/modeling/filters/operators/between-dates)                   | Filters time fields for dates falling within a specified range.                         |
| [`date_offset_from_query`](/modeling/filters/operators/date-offset-from-query) | Specifies a filter dynamically relative to the date filter applied to a workbook query. |
| [`day_of_month`](/modeling/filters/operators/day-of-month)                     | Filters time fields by the day of the month.                                            |
| [`day_of_quarter`](/modeling/filters/operators/day-of-quarter)                 | Filters time fields by the day of the quarter.                                          |
| [`day_of_week`](/modeling/filters/operators/day-of-week)                       | Filters time fields by the day of the week.                                             |
| [`day_of_year`](/modeling/filters/operators/day-of-year)                       | Filters time fields by the day of the year.                                             |
| [`hour_of_day`](/modeling/filters/operators/hour-of-day)                       | Filters time fields by the hour of the day.                                             |
| [`month_of_year`](/modeling/filters/operators/month-of-year)                   | Filters time fields by the month of the year.                                           |
| [`on_or_after`](/modeling/filters/operators/on-or-after)                       | Filters time fields for dates on or after a specified date.                             |
| [`quarter_of_year`](/modeling/filters/operators/quarter-of-year)               | Filters time fields by the quarter of the year.                                         |
| [`time_for_duration`](/modeling/filters/operators/time-for-duration)           | Filters time fields for a specific duration starting from a given point in time.        |

## Numeric

| Name                                                                               | Description                                                                    |
| ---------------------------------------------------------------------------------- | ------------------------------------------------------------------------------ |
| [`between`](/modeling/filters/operators/between)                                   | Filters numeric fields for values within a specified range.                    |
| [`greater_than`](/modeling/filters/operators/greater-than)                         | Filters numeric fields for values greater than a specified number.             |
| [`greater_than_or_equal_to`](/modeling/filters/operators/greater-than-or-equal-to) | Filters numeric fields for values greater than or equal to a specified number. |
| [`less_than`](/modeling/filters/operators/less-than)                               | Filters numeric fields for values strictly less than a specified number.       |
| [`less_than_or_equal_to`](/modeling/filters/operators/less-than-or-equal-to)       | Filters numeric fields for values less than or equal to a specified number.    |

## String

| Name                                                               | Description                                                             |
| ------------------------------------------------------------------ | ----------------------------------------------------------------------- |
| [`case_insensitive`](/modeling/filters/operators/case-insensitive) | Modifies string filter operators to perform case-insensitive matching.  |
| [`contains`](/modeling/filters/operators/contains)                 | Filters string fields for values that contain a specified substring.    |
| [`ends_with`](/modeling/filters/operators/ends-with)               | Filters string fields for values that end with a specified substring.   |
| [`starts_with`](/modeling/filters/operators/starts-with)           | Filters string fields for values that start with a specified substring. |