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:
|Numeric and date fields:||
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.
|Assignable||Description | equal to | null||entities with blank description|
|Assignable||Description | not equal to | null||all entities but ones with blank description|
Custom Field values
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