Skip to content

Condition Filters

A Condition Filter limits the results that will be returned on a collection by comparing a field against another field on the same collection.

Creation

Condition Filters can be added by selecting the Add filter option from a field menu. For most fields this will default to creating a Value Filter; to create a condition filter select Condition from the Type dropdown.

These will bring up a window for creating a condition filter, with the following configuration options:

  • Type: What type of filter to create; set to Condition for a Condition Filter.
  • Alias: Display name for the filter. (optional, used when switching between multiple filters on a single field when editing)
  • Handle: External handle to use in modifying or overriding this filter when running this DeepQuery in other contexts.
  • Field: Which existing field this filter will act on. This is preset by the field selected to add a filter to.
  • Condition: The operation to apply between Field and Compare To
  • Compare To: Which existing field to compare to Field. This is hidden for some values of Condition.

!Create New Condition Filter

Click Save to create the new filter and add it to the DeepQuery. Click Cancel to close the window without creating the filter.

Conditions

The following conditions are supported.

Condition Description Note
= Field is equal to Compare To
Field is not equal to Compare To
> Field is strictly greater than Compare To
Field is greater than or equal to Compare To
< Field is less than Compare To
Field is less than or equal to Compare To
Like Field matches the string pattern Compare To See Sql Server LIKE
IsNull Field is NULL Compare To option hidden
IsNotNull Field is not NULL Compare To option hidden