Filters for rows and columns | Targetprocess - Visual management software

Filters for rows and columns

When creating a view with vertical and horizontal lanes you may see a number of empty rows or rows that you do not want to pay attention to right now. Displaying the correct information in the first few rows is important as data that didn't make it to the top can be missed.

Filters for rows and columns. Image 1

This might be a bit confusing especially after having applied a filter for cards. For example, if you apply a filter to Tasks like

?Iteration is Current

the tasks from other iterations will be hidden but you will still see all user stories from the selected projects and teams.

In some cases Hide empty lanes button can quickly and efficiently make all empty rows and columns on your Board view invisible.

Filters for rows and columns. Image 2

However it may happen that this button cannot address your use case. Should it happen, you're welcome to try to use Filters instead.

You can (and in many cases should) apply a filter to lanes as well. Generally speaking, a filter for lanes could be different from the one for cards, providing great flexibility in getting the view you need. In the example above you could apply the same filter to rows to see stories from the current iterations only. If you wish to filter out stories that have tasks in the current iteration (in other words, remove the empty rows), try something like

?Tasks.Where(Iteration is Current)

Filters for rows and columns. Image 3

Also, you might want to hide the first empty row - “No User Story”. You can do it by adding “it is not None” to the filter. So, the resulting filter for rows would be

?Tasks.Where(Iteration is Current) and it is not None

Here are some helpful examples of the filters that could be applied to lanes in this board:

Lane (Row / Column)CardFilter for laneResult
User StoryTasks, Bugs?Tasks.count > 0Stories only with Tasks
User StoryTasks, Bugs?Tasks.where(AssignedUser.Contains(Me))Stories only with Tasks assigned to you
FeatureUser Stories, Bugs?UserStories.Where(AssignedUser.Contains(Me)) or Bugs.Where(AssignedUser.Contains(Me))Features only with user stories or bugs assigned to you

General principles

Syntax rules of filters above and below is described in article on Advanced Filters. When you apply a filter to lanes, then cards are considered as inner Collections.

Helpful examples

Filters for Time List

Find useful example in the article about Filters for Time list views and visual reports.

Filters by Projects and Teams

It is not possible to refer to currently selected projects and teams in filters so far. Instead, you have to manually list projects and / or teams one by one or use Me keyword to build smart reference in your advanced filters by projects and teams.

Filters for Relations

It is possible to apply filters to Inbound Relations and Outbound Relations lanes. More information: Filters by Relations

Filters for Timeline views

On Timeline view it is possible to hide rows only. Columns and filters for them are not supported. The Backlog column contains entities that are not planned and are have not been started. It is not possible to hide Backlog column on Timeline views.

Still have a question?

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

Find out more about our APIs, Plugins, Mashups and custom extensions. Join our community of passionate users and even discuss directly with our developers.