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

JQL to ignore but not prevent viewing sub-tasks

Hope someone can help with a quick filter challenge. I'm pretty sure my overall approach is wrong (not a dev or techie) and would be grateful for any pointers.

SCENARIO: we prefix out top 5 kanban issues (but not their sub-tasks) P1 to P5 so we can easily isolate them at stand-ups, etc. I want quick filters to return the Pn issues (and their sub-tasks) and another to return the non-Pn issues (and their sub-tasks) Here's what I've tried...

Return Ps 

summary ~ P1 OR summary ~ P2 OR summary ~ P3 OR summary ~ P4 OR summary ~ P5

This works except I can't expand the swimlane to see the associated sub-tasks because they're excluded as they don't have the Pn indicator.

Return not-Ps (ver. 1)

summary !~ P1 OR summary !~ P2 OR summary !~ P3 OR summary ~ !P4 OR summary !~ P5

This doesn't work because sub-tasks don't carry the Pn prefix and the issue and sub-tasks are returned.

Return not-Ps (ver. 2)

So I excluded the sub-task issuetype:

NOT (summary ~ P0 OR summary ~ P1 OR summary ~ P2 OR summary ~ P3 OR summary ~ P4 OR summary ~ P5) AND issuetype != Sub-task

This returns the correct issues at the cost again of being unable to expand the swimlane to see the sub-tasks because they're now excluded!

Thanks :-)

1 answer

Hi Des,

Thank you for your question.

I can confirm that if you want to return the issues within the subtasks as well then you will need to install an add on that provides a search function that can search for subtasks below an issue that macth a specific query.

I can confirm that ScriptRunner for Jira can do this and we have a version of this for Jira Server / Data Center or Jira Cloud.

If you are uisng Jira Cloud then ScriptRunner for Jira Cloud can help with this with the subtasksOf() JQL function that it provides here which means you would be able to write your current query and then a query to return the subtasks below those issues using a syntax similar to as shown on the documentation page above.

I can also confirm that if you are using Jira Server / Data Center  then ScriptRunner for Jira Server / Data Center can help with this with the subtasksOf() JQL function that it provides here which means you would be able to write your current query and then a query to return the subtasks below those issues using a syntax similar to as shown on the documentation page above. 

I hope this information helps.

Regards,

Kristian

Thanks for the excellent feedback, Kristian. Really appreciate it and I'll look into the ScriptRunner add-on soon.

 

Cheers, Des

Hi Des,

You are welcome.

Regards,

Kristian

Suggest an answer

Log in or Sign up to answer
TAGS

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