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

Next challenges

Recent achievements

Recognition

  • Give kudos
  • My kudos

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

Trying to figure out a syntax for a filter

Hi everyone

Apologies if this question has been answered in a thread before - I'm trying to figure out the syntax for displaying subtasks in an active user story that's in a specific epic.

I'm new to JQL and I've created a few filters for my dashboard I'm using with my team, but this last one seems a bit trickier for me to figure out.

Any help or direction to where this might have been answered is much appreciated.

Thank you

Aimee

2 answers

1 accepted

0 votes
Answer accepted

As per Jack's suggestion - I got round the problem using this:

issuetype = Sub-task AND labels = "[pi100]" AND status in ("To Do", "In Progress", Closed, Done)

I added a label to the epic and all its related issue types to get round the problem.

Good one! Aimee

Like Aimee Davies likes this

Hi Aimee,

To retrieve all actives (non-resolved) issues within an Epic (EMEA-58 in our example) you need to type (this can be done out-of-the-box) the following:


"Epic Link" IN (EMEA-58) AND resolution IS NOT EMPTY

 

However, you need a third-party app to perform more complex queries, see an example. Using JQL Booster Pack (FREE), you can:


Retrieve all actives (non-resolved) issues for all actives (non-resolved) Epic of a specific project (EMEA project in our example) by typing:

 

issue in issuesInEpics("project = EMEA AND resolution IS NOT EMPTY") AND resolution IS NOT EMPTY



You can also retrieve subtask within issues that matches a query. For example, retrieve all subtask within actives (non-resolved) Stories:

issue in subtaskOf("type = Story AND resolution IS NOT EMPTY")



All together, display subtasks in active issues that's in a EMEA-58 Epic

issue in subtaskOf('"Epic Link" = EMEA-58 AND resolution IS NOT EMPTY')



DISCLAIMER: I developed this app myself

 

Let us know if the given examples solves your problem or if you need further support with this topic,
Regards

Hi Jack

Thank you for your reply. I managed to figure out something that works without needing the plugin. Because of where I work I'm not able to get plugins easily, but thank you so much for assisting.

Aimee

Hi Aimee,

If you solved the problem in a way that hasn't been suggested yet in this thread, please I encourage you to reply your original message to tell us what was the final solution for the problem, you can also mark your own reply as an 'Accepted answer'.

In addition, by doing this the post will automatically gain the "Solved:" prefix in search results to indicate other people that no further support is needed.

Kind Regards.

Hi Jack

This is how I got round it:

issuetype = Sub-task AND labels = "[pi100]" AND status in ("To Do", "In Progress", Closed, Done)

I added a label to the epic and all its related issue types in its stead as I couldn't link a sub-task to an epic.

Thanks

Aimee 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

How to create Jira issus from Excel file?

When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...

4,549 views 22 32
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