You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.
View groupJoin the community to find out what other Atlassian users are discussing, debating and creating.
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
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.... :-(
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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")
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Can you confirm exactly what you have tried?
type != sub-task is a totally different question to issuetype in subtaskIssueTypes()
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
what is issuetype in subtaskIssueTypes() give you then?
Might be a silly question but never used it...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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. ;-)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
Connect with like-minded Atlassian users at free events near you!
Find an eventConnect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
Host an eventYou're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.