nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I hide sub-tasks on active scrum board using sql query on my swimlane

Jonny_b0juj7

We have an active scrum board.

I want to hide the sub-tasks on the board at the moment as they are mainly tech tasks.

I have used quick filters, but want to find a sql query that I can use on my swimlane settings and NOT use quick filter.

Any help is appreciated.

Cheers

Accepted answers

Nic Brough -Adaptavist-

Swimlanes and quick filters both use JQL and it's probably the same query for both functions.

If, for example, you set up a quick filter for "issuetype in subtaskIssueTypes()", then when a user clicks it, the board should hide all the issues that are not sub-tasks.

The same query, when used as the first and only swimlane, will split the board into two lanes horizontally, the top lane showing sub-tasks, the bottom lane showing standard issue types (the bottom lane shows all issues not selected for display in another swimlane)

John Funk

Hi Jonny,

If you want to hide sub-tasks completely, you should modify the actual board filter and not try to do it with swimlane queries.

Go to Board Settings > General > then click on Edit filter query. Add your AND type != sub-task JQL there. Be sure to save it.

All comments

Jack Brickey

you would need to be using Swimlanes by queries and add "... AND type != sub-task" to each swimlane you have defined.

Nic Brough -Adaptavist-

Swimlanes and quick filters both use JQL and it's probably the same query for both functions.

If, for example, you set up a quick filter for "issuetype in subtaskIssueTypes()", then when a user clicks it, the board should hide all the issues that are not sub-tasks.

Jonny_b0juj7

Thanks for getting back to me so quick,

yep, I am using swimlane by queries, and I tried that != sub-task and no luck.... :-(

Jonny_b0juj7

Thanks for coming back Nic. I want to hide the sub-tasks totally.... ideally not in a separate swimlane. I have tried the "..AND type != sub-task" but no luck, still coming through.

Jack Brickey

please share one of your complete filters

John Funk

Hi Jonny,

If you want to hide sub-tasks completely, you should modify the actual board filter and not try to do it with swimlane queries.

Go to Board Settings > General > then click on Edit filter query. Add your AND type != sub-task JQL there. Be sure to save it.

Jonny_b0juj7

Hmm, I did come across this in my search. I'll need to speak to the ultimate boss of boss who owns the permissions as don't think it will let me. Thanks for the confirmation John.

Does this mean you "can't" do it via swimlanes, but just that you "shouldn't" out of interest?

Nic Brough -Adaptavist-

Can you confirm exactly what you have tried?

type != sub-task is a totally different question to issuetype in subtaskIssueTypes()

Jonny_b0juj7

This is what we currently have in there:

project = "project name" AND "Epic Link" = "Project name" AND issuetype in ("Frontend Bug", "Frontend Story", "Frontend Task", "Backend Bug", "Backend Story", "Backend Task")

John Funk

In the short term - try adding that code in the Sub-filter at the bottom and test it out. That should work and you don't have to confer with the ultimate boss of bosses.

Around here we just call him Nic. ;-)

Jonny_b0juj7

what is issuetype in subtaskIssueTypes() give you then?

Might be a silly question but never used it...

Geeta_9d5x8p

I tried with editing filter by adding AND issuetype != Sub-task at the end of it, and save the filter. - But this didn't work.

Instead i tried as by adding and issuetype not in subtaskIssueTypes() and this worked

before

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-software

jira-software-cloud

board

atl-gruland

scrum

sub-task