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 · Accepted solution]

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.

[Trudy Claspill]

Hello @Sherwin Soriano 

Did one of the responses provide help you solve your requirement? If so, please consider clicking on the Accept Answer button for that response, which will mark your Question as Solved.

[Charlotte Santos -Appfire-]

Hi @Sherwin Soriano 

I’m Charlotte, a support engineer at Appfire and I’m here to help you.

Unfortunately, natively, you’ll not be able to do it dynamically.

In the app where my team works, JQL Search Extensions for Jira, you can use this query to see stories in the status backlog whose parent epics are in the status in progress:

issue in childrenOfEpicsInQuery("status = 'In progress'") AND project = "Project A" AND type = Story AND status = Backlog

 Please contact our support if you have any other questions about this query.

We’ll be happy to help you! 😉

[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