I want to see filtered issues on kanban board

[Lukáš Rybnický]

Hey there,

I have problem with filtering issues for kanban board to QA team.

We have around 80 projects (lets call them project Game 1, Game 2, ...etc.). All the projects have an Epic Issue called Testing(aswell, development, ...etc.), and in this Epic are stories, bugs, tasks, sub-tasks. And then we have a one project that contains all 80 games. This project(lets call it hybrid) is built because, we are upgrading games and trying to get them on new server, etc. But here comes the problem. In this one projects, all the games are 'Epics'. So we got like 80 Epic's just from games. Inside of epic's are tasks/stories named as "Testing" and then are created Sub-Tasks to show current bugs, ..etc. 

One of the main problems is, that we aren't using labels and components as much as it should be. 

I was using filter as:

" project in (Game 1, Game 2, etc...) " and tried to add: summary ~ text, epic name =/~ Testing, issue types etc... 

But, i just could not figure it out somehow, so i realized i have to ask community for help, and hope for some suggestions.

My questions are:

• How to get Bug's/stories/tasks/sub-tasks to kanban board from Project: Game 1 and then tasks/stories and sub-tasks from Project: Hybrid by using JQL?
• Is it possible with labels  or components to filter those issues? If yes then:
  • Can i somehow add labels or components to every issue, without opening everyone? I mean configure them by bulk feature? (it's so many issues....) 
• Are there some add-ons to filter those issues easier?

Any suggestions?

PS. I'm just starting with Jira as "admin" (we don't have any admin to maintain Jira), and  i have a little knowledge of these features.  Actually trying to learn and read as much documentations as possible, and reading Rachel Wright's book too. 

Thanks, and have a great day ;)

Best regards,

Lukáš

[mamer_atlassian · Accepted solution]

Hi Lukáš,

With regards t your inquiries:

How to get Bug's/stories/tasks/sub-tasks to kanban board from Project: Game 1 and then tasks/stories and sub-tasks from Project: Hybrid by using JQL?

You may do this with a JQL query similar to the below:

(Project = "Game 1" and issuetype  in ("Bug","story","task","sub-task")) OR (Project = "Hybrid" and issuetype in ("story","task","sub-task"))

 Is it possible with labels  or components to filter those issues? If yes then:

Can i somehow add labels or components to every issue, without opening everyone? I mean configure them by bulk feature? (it's so many issues....) 

If you set labels, you can use the bulk change to update them. Just search for the issues you want with JQL, then on the top right corner, click Tools > bulk change. Here is the KB article on how to do that.

Are there some add-ons to filter those issues easier?

There are several add-ons in the marketplace that offer extended JQL functionality, you may take a look at them and see if they cover your requirement, here are some suggestions:

• Jql search extensions for jira
• Scriptrunner for jira

[Lukáš Rybnický]

Hi Muaamar,

thanks for reply. Your query worked good for me, but i got another question. Is there possibility to filter only issues which are in “testing” issue? I mean i can filter all issues include word “testing”. But i can’t figure out how to sort out issues which are in “testing” issue.
Project: Game 1
Epic: Testing
Issue type: Story, Bug, etc. (Current bugs)
i want to filter issues which are in epic ( but we didnt have labeled those issues)

Project: Hybrid
Epic: Game 1
Story: Testing
Sub-Tasks: current bugs
I want to filter issues which are in “testing” ( as well those sub-tasks aren’t labeled).

And if im not wrong (inform me if i do) Sub-tasks wont be visible on kanban board?

Thanks.
Best regards,
Lukáš

[mamer_atlassian]

Hello Lukáš,

You may try to use the Epic Name for the first case. For the second, as I understand, you seem to be using a story name called testing, you can search the summary of the story with something like the below:

(Project = "Game 1" and issuetype  in ("Bug","story","task","sub-task") and "Epic Name"="Testing") OR (Project = "Hybrid" and issuetype in ("story","task","sub-task") and summary ~ "Testing")

With regards to the Kanban boards, the sub-tasks can be visible. You may need to enable the sub-tasks under board configuration > card layout and also enable ranking. The following pages discuss the same: 

• https://community.atlassian.com/t5/Jira-questions/How-to-show-the-subtasks-in-the-backlog-sprint-tree/qaq-p/412630
• https://confluence.atlassian.com/jirakb/how-to-display-sub-task-below-the-parent-task-in-the-backlog-779158697.html

Kind Regards,

Muaamar