Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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 

3 answers

0 votes
Jack Community Leader Jan 27, 2021

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

Thanks for getting back to me so quick,

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

Jack Community Leader Jan 27, 2021

please share one of your complete filters

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")

0 votes

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)

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.

Can you confirm exactly what you have tried?

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

what is issuetype in subtaskIssueTypes() give you then?

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

It selects for all issue types that are sub-task types, irrespective of their names.  The opposite function is standardIssueTypes() which selects all issue types except sub-task types.

Like Jonny likes this
0 votes
John Funk Community Leader Jan 27, 2021

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.

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?

John Funk Community Leader Jan 27, 2021

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.  ;-)

Like Jonny likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
TAGS
Community showcase
Published in Jira

Announcing the waitlist for Jira Work Management

Hey there Cloud Community members! We’re excited to give you the first glimpse of the new home for business teams on Jira — Jira Work Management. Jira Work Management is the next generation of J...

149 views 3 7
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you