Finding issues with issueinEpic

[Thomas Cucolo]

I am trying to find issues that have a status of In Progress and the Epic is is in a Category Status of To Do.

project in ("Project1", "Project2") AND issuetype = Epic AND status in (Funnel, Analyzing, Backlog) AND issueFunction in issuesInEpics("project in('Project1', 'Project2') AND issuetype = story AND Status not in('Open', 'Ready')")

I run the first part and return something and I can search those Epics and find stories In Progress. I am unable get anything to return when using this filter.

Is there a website that can help teach me how to build better filters and has training on these functions?

[Ankit Srivastava · Accepted solution]

Hi @Thomas Cucolo 

We need to use the nested filter here to fetch the required result:

Modified version of your JQL query:

---

Project in('Project1', 'Project2') AND issuetype = story AND Status not in('Open', 'Ready') and  issuefunction in linkedIssuesOf ("project in ("Project1", "Project2")  AND issuetype = Epic AND status in (Funnel, Analyzing, Backlog)")

---

================================================

Issues that have a status of In Progress and the Epic is is in a Category Status of To Do:

---

project in ("Project1", "Project2")  AND issuetype = Epic AND Status = ("In Progress")

---

You can save above query as filter, suppose the filter Id be 12345 ( you may check on URL once you saved the query as filter), then use it in next query as a nested filter/query

---

Project in('Project1', 'Project2')  AND Status = "In Progress" and  issuefunction in linkedIssuesOf ("filter=12345")

---

==========================================================

Please refer the Scriptrunner documentation for advanced JQL Function search
https://scriptrunner.adaptavist.com/latest/jira/jql-functions.html


Hope this will help.


Regards,
Ankit Srivastava

[Thomas Cucolo]

Thank you for the reply I am having issues with getting a return. I made a story from an Epic in Funnel status an In Progress story and nothing is getting returned.

[Thomas Cucolo]

Still working with you answer