Filters in Tabular Reports

SEE ALSO:

You can set filtering for tabular reports either or both by the properties of a main entity and the properties of related entities.

Go to the Filters tab, as you create/edit a tabular report. The following operators are available:

Field type	Operators	Examples
Numeric and date fields:	equal to not equal to greater than less than greater than or equal to less than or equal to	Iteration:ID \| equal to \| 244 Start date \| greater than \| today-7 Last Comment date \| less than or equal to \| 01-Dec-2011
Text fields:	equal to not equal to contains not contains	Assigned User:Login \| equal to \| Kate Description \| not contains \| some word
Boolean fields:	equal to not equal to	Entity State:Is Final \| equal to \| True Assigned User: Is Administrator \| equal to \| False

For Date, you can either pick a date from the calendar, or use the 3 canned values:

Here’s an example. A report with this filter will show only the bugs created over the last week:

More examples. Filter by Iteration: Name to show User Stories from the backlog:

Filter out the entities tagged “urgent”:

To find entities with Tag having two or more words (space separated) put the whole search phrase into single quotes.

Example: Tags / contains / 'two words'

This filter will show the bugs from Active projects only:

All filters are combined with AND rules. It is not possible to combine two different filters using OR condition.

Filters for blank values

Special keyword null is used to filter entities by blank value in the Description field.

Entity	Filter	Result
Assignable	Description \| equal to \| null	entities with blank description
Assignable	Description \| not equal to \| null	all entities but ones with blank description

Special keywords null or empty are used to filter entities by blank value set or selected in a Custom Field.

Custom Field Name | equal to | empty

Custom Field Name | not equal to | null

We're here to help! Just contact our friendly support team.

Find out more about our APIs, Automation Rules, Mashups and custom extensions.