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.

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.

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)

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.

  • Mikhail

    I would like to create a view where rows are for member of a development team and columns are sprints with small twist. I only want t o show cards where the team member is assigned as “Developer”. Currently it shows cards where they assigned as “Developers” and “Reviewers”

  • Bogdan Skaskiv

    Hello Mikhail,
    You can create such view by applying two filters. One of them should be filled out for the cards(User Stories,for example): ?Assignments.Where(Role.Name is ‘Developer’ and Role.Name is not ‘Reviewer’). Another one should be added for the “Person” lane: ?TeamMembers.Where(Team.Name is “Development Team”).

  • Mikhail

    That does quite work. May be because how our team set up?

    So we have a team; 9 people all of them have Role ‘Developer’. For a particular task they can be assigned as ‘Reviewer’

    It is my understanding that Role in the

    ?Assignments.Where(Role.Name is ‘Developer’ and Role.Name is not ‘Reviewer’).

    refers to the Role a person has on the team, not what he was assigned on a card

  • Bogdan Skaskiv

    Role in that expression refers to the role assigned on a card not on the team. Though i’ve made a mistake in the proposed expression so it’s not working as supposed. Please, use this one instead: ?Assignments.Where(Role is ‘Developer’) and not Assignments.Where(Role is ‘Reviewer’)

  • Tomas

    I would need to create general filter for whole team that as developer I sees only stories with assigment “developer” without assigment “QA Engineer” but only in column IN REVIEW I want again show stories where I am assigned as “QA Engineer”?

  • Andrey Metelsky

    Hi @disqus_tcVSUGPg4l:disqus
    In your case “Hide not responsible” mashup should fit your needs. Please see more here for details:

    Andrey M.

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.