Docs »

Search »

Filters

A query is a list of filters separated by a space. Each filter uses the format:



filter:expression


The possible expressions depend on the type of filter:

Text

These expressions can be used on text-based filters.

Term

Simple text (without spaces) can be used as the entire expression:



firstName:Kina


Phrases

Enclose phrases in double quotes ("):



subject:"This phrase contains spaces"


Wildcards

Use asterisks (*) to denote wildcards:



mask:abc*


Sets

Find records that match any of the given values:



color:[red,green,blue]


Negation

Prefix an expression with an exclamation point (!) to negate it. This returns any records that don’t match.



status:!open


Fulltext

Many records provide a default full-text filter that’s used when you type an expression without specifying a filter.

This is a more efficient way to search records with a large amount of text (e.g. email messages, comments).

Terms

By default, records will be returned if they match all of the given terms.



bug bluetooth report


Phrases

Enter text within quotes to search for exact phrases:



"bug report"


Numbers

These expressions can be used on numeric filters.

Equal

To filter by records with an exact numeric value, use a number as the expression:



age:35


Not Equal

Find all records that don’t match a value by prefixing the expression with an exclamation point (!):



priority:!1


Greater than

To filter by records with a value greater than the expression, use > or >=:



age:>21


Less than

To filter by records with a value less than the expression, use < or <=:



order:<=100


Between

Find records with a value within a range by using ...:



importance:25...75


Sets

Find records that match any of the given values:



importance:[0,50,75]


Booleans

These expressions can be used on boolean filters.

True

To filter for records with a true boolean value, you can use the expressions:

  • yes
  • y
  • true


checkbox:y


False

To filter for records with a false boolean value, you can use the expressions:

  • no
  • n
  • false


isAdmin:n


Dates

These expressions can be used on date-based filters.

Since

To filter by records with a date after a given point in time:



created:today




created:"-1 month"




created:"2018-01-01"




created:"January 1 2018"




created:"first day of this month"


Between

To filter by records with a date within a given range, provide two dates separated by the word to:



created:"today to now"




created:"January 1 to June 30"




created:"-1 year to -6 months"




created:"big bang to first day of this month"


Nullness

You can match records by having, or not having, any value for a particular filter.

This is particularly useful for custom fields.

Null

Use the expression null to find records without any value set:



sla.level:null


Not null

Use the expression !null to find records with any value set:



checkbox:!null


Choosers

Chooser filters match fields that contain record IDs.

By convention, these filter names usually have an .id suffix (e.g. bucket.id:).

Chooser filters support all numeric expressions.

ID

To find records with a single matching record ID:



group.id:1


IDs

To find records matching any of a list of record IDs:



group.id:[1,2,3]


Links

These expressions can be used on link filters.

To filter by records with a link to a specific other record type, use its alias as the expression:



links:ticket


You can also use deep search to filter records based on any property of linked records.

Append the record type alias to links following a period (.), then the expression can be any search query for that record type:



links.ticket:(mask:a*)


Watchers

These expressions can be used on watcher filters.

Names

To filter for records watched by specific workers, enter partial names:



watchers:kina,karl


Me

To filter for records you’re watching, use the me expression:



watchers:me


Any

To filter for records watched by any workers, use the any expression:



watchers:any


None

To filter for records not watched by any workers, use the none expression:



watchers:none


IDs

To filter for records watched by specific worker IDs, enter a comma-separated list of IDs:



watchers:1,2,3