Trying to figure out a syntax for a filter

[Aimee Davies]

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

[Aimee Davies · Accepted solution]

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.

[Jack Nolddor _Sweet Bananas_]

Good one! Aimee

[Jack Nolddor _Sweet Bananas_]

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

[Aimee Davies]

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

[Jack Nolddor _Sweet Bananas_]

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.

[Aimee Davies]

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