nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Aimee Davies

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.

All comments

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

Aimee Davies

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server