I have this link structure in JIRA: "Initiative" then "task" (and "Epic" then "task"). I would like to filter all unresolved issues in a particular Initiative.
I can get the unresolved direct children of the Initiative with this:
issueFunction in linkedIssuesOf("resolution is empty and issuekey=PM-20", "is Initiative parent of") and resolution is empty
but I'm not sure how to add in the children of any child epic(s). So far, using the Scriptrunner insert function wizard, I have this:
issueFunction in issuesInEpics(" issueFunction in linkedIssuesOf("issuekey= PM-20", "is Initiative parent of") and resolution is empty") and resolution is empty
The error I get is "Failed to get issues in epic". I don't have any experience with nested queries. Help..?
Thank you for the question.
If you are using Scriptrunner For Jira Cloud, we do not support running nested queries inside of the subqueries for JQL functions.
I can, however, confirm that this means that you will first to create a query to return the results for your enhanced search function and you will need to save this as its own filter.
You will then need to create a second query which calls this saved filter inside of the subquery for your enhanced search function in order to return all the issues in the Epics for the filer you saved previously.
For your reference, I can confirm that the JQL that you would use in the subquery to return the results of the filter is filter = <NameOfFilterHere>.
You will then be able to update the JQL for your second query to be similar to the below so that it returns the results of the first filter inside the subquery for the JQL function.
issueFunction in <JqlFunction>("filter = <NameOfFilterHere>")
I hope this information helps.
However, I have looked into your question further and believe you may be able to use the approach outlined in the Atlassian Community Article located here along with the linkedIssuesofRecursive() function and here a potential guide to achieving your requirement.
I hope this helps.
Calling all collaborators and Confluence users! Our Appy Hours event on September 29th features 4 presenters demoing functionality to superpower Confluence. Don't miss learning about these apps i...