Is this possible for JQuery?

[Sherwin Soriano]

We wanted to query all story issue types in specific boards that we have. Story has a parent epic issue type.

Query is Project = "Project A" and issue type = "Story" and status = "Backlog".

My manager is asking if the query can be limited to stories in which the epic parent status is equal to "In Progress".

Is this possible?

[Trudy Claspill]

Hello @Sherwin Soriano 

Do you have any third party apps that extend JQL capabilities, like the ones listed here?

https://marketplace.atlassian.com/search?query=JQL&product=jira&hosting=cloud&sort=relevance

What do you want to do with the results?

With only native JQL capabilities you will not be able to achieve your requirement.

Depending on what you want to do with the results, you might be able to get the results using an Automation Rule.

[Pasam Venkateshwarrao]

Hi @Sherwin Soriano 

This is tricky but doable. But you need the jql functions from the script runner plugin 

The query is like this:

status != Done and 
    issueFunction in linkedIssuesOf("status = Done", "has epic") and 
    not issueFunction in linkedIssuesOf("status != Done", "has epic")

To translate this:

status != Done: Find epics that are not done. You might need to change the status names

issueFunction in linkedIssuesOf("status = Done", "has epic"): This is the tricky but... find issues that have a "has epic" link to an issue with status = Done.

not issueFunction in linkedIssuesOf("status != Done", "has epic"): Even harder here is the requirement that all the linked issues must be Done, so we filter out any epics that that have stories that are not done.

Not the sort of thing you could expect a user to do but you might be able to set it up for them.

Hope this helps