Brief summary of this article:
These Advanced Filters help to select, hide or highlight data in planning and tracking Views and Visual Reports. You can filter your cards by Releases, Sprints (Iterations) and Team Iterations they belong to. Also you can filter cards and lanes that represent Releases, Sprints (Iterations) and Team Iterations themselves.
Assignable entities are work items such as User Stories, Bugs, Tasks, Features, Epics, Requests, Test Plan Runs, Test Plans. Filters below are work for any of these types of entities selected as cards.
| Entity | Filter | Result |
| Assignable | ?Release is '2.0'
?Iteration is '2.0.1' ?TeamIteration is 'Beta' |
Entities from the Release '2.0' / Iteration '2.0.1' / TeamIteration 'Beta'. |
| Assignable | ?Release is None
|
Entities not assigned to any Release. Filters for Sprint (Iteration) or Team Iteration work the same way. |
| Assignable | ?Release is not None
|
Entities assigned to any Release. Filters for Sprint (Iteration) or Team Iteration work the same way. |
| Assignable | ?Release is not '2.0' | Entities from any Release, but '2.0'. Entities not assigned to any Release are excluded. Filters for Sprint (Iteration) or Team Iteration work the same way. |
| Assignable | ?Release is '2.0' or Release is None | Entities from any Release, but '2.0'. Entities not assigned to any Release are included. Filters for Sprint (Iteration) or Team Iteration work the same way. |
Keywords supported in filters
Current, Future and Past keywords help to filter Releases, Sprints (Iterations) and Team Iterations that are in progress, next or past.
Current
Current Releases, Sprints (Iterations) and Team Iterations have Start Date set to today or a past date and End Date set to today or a date in future.
| Entity | Filter | Result |
| Release
Sprint (Iteration) Team Iteration |
?It is Current | only current scopes of work |
| Assignable | ?Release is Current
?Iteration is Current ?TeamIteration is Current |
all the entities from the current scopes of work |
Future
Future Releases, Sprints (Iterations) and Team Iterations have both Start Date and End Date set to dates in future.
| Entity | Filter | Result |
| Release
Sprint (Iteration) Team Iteration |
?It is Future | all future scopes of work |
| Release
Sprint (Iteration) Team Iteration |
?It is Future(2) | takes COUNT of next Releases, Sprints (Iterations) or Team Iterations
works as filter, not supported in Visual Encoding rules |
| Assignable | ?Release is Future
?Iteration is Future ?TeamIteration is Future |
all the entities from the future scopes of work |
| Assignable | ?Release is Future(2)
?Iteration is Future(2) ?TeamIteration is Future(2) |
all the entities from the COUNT of next Releases, Sprints (Iterations) or Team Iterations
works as filter, not supported in Visual Encoding rules |
Past
Past Releases, Sprints (Iterations) and Team Iterations have both Start Date and End Date set to past dates.
| Entity | Filter | Result |
| Release
Sprint (Iteration) Team Iteration |
?It is Past | all past scopes of work |
| Release
Sprint (Iteration) Team Iteration |
?It is Past(2) | takes COUNT of last Releases, Sprints (Iterations) or Team Iterations
works as filter, not supported in Visual Encoding rules |
| Assignable | ?Release is Past
?Iteration is Past ?TeamIteration is Past |
all the entities from the past scopes of work |
| Assignable | ?Release is Past(2)
?Iteration is Past(2) ?TeamIteration is Past(2) |
all the entities from the COUNT of last Releases, Sprints (Iterations) or Team Iterations
works as filter, not supported in Visual Encoding rules |
More examples
| Entity | Filter | Result |
| Release
Sprint (Iteration) Team Iteration |
?It is Current or It is Future | current Release, Sprint (Iteration) or Team Iteration and all next ones |
| Feature | ?UserStories.Where(Iteration is Current) | features with user stories from the current iteration |
There are some filters that are recommended to identify a Release or Sprint being in danger of extending past the planned End Date.
| Entity | Filter | Result |
|---|---|---|
| Release
Iteration TeamIteration |
?It is Current AND ForecastEndDate <= EndDate | current releases and sprints that are on track |
| Release
Iteration TeamIteration |
?It is Current AND ForecastEndDate > EndDate | releases and sprints that are delayed according to currently made forecasts |
Hide backlog (empty) swimlanes:
| Entity | Filter | Result |
|---|---|---|
| Release
Iteration TeamIteration |
?It is not None | Hides "Backlog", "No Release", "No Iteration", "No Team Iteration" swimlanes. |
Still have a question?
We're here to help! Just contact our friendly support team.
Find out more about our APIs, Automation Rules, Mashups and custom extensions.