Querying multiple Parent Items in single query

[JD]

Hi - How do I add multiple Parent Items to this single query? where my Parent Items are: 28972, 20810, 27024?

issuefunction in issuesInEpics("\"Parent Item\" ~ 28972") and issuetype = defect and status not in (Closed, Cancelled, Resolved, DEFERRED, DONE)

[Pasam Venkateshwarrao · Accepted solution]

Hi @JD 

Welcome to the community,To achieve this you have to use Third-party Add-on Script Runner,In Jira Cloud you can only use the issueFunction() JQL function provided by ScriptRunner on the Enhanced Search page as described in the documentation here.

Example:

project = ABC AND issuetype = "Epic" AND resolution = Unresolved 
AND issueFunction in linkedIssuesOf("resolution != Unresolved", blocks) 
AND NOT issueFunction in linkedIssuesOf("resolution IS EMPTY", blocks)

 Hope this helps

[Pasam Venkateshwarrao]

@JD is your query resolved or still finding any other solution

[JD]

Hey. I found a way to join the IDs. I pretty much created multiple queries and joined them. 

Thanks all for the help. 

[Trudy Claspill · Accepted solution]

Hello @JD 

Welcome to the Atlassian community.

Do you know if you are working with Jira Cloud or Jira Data Center?

Is "Parent Item" a custom field you have added to your issues? If so, what type of custom field is it?

For subqueries that you want to use in functions like issuesInEpics() I recommend that you use the native Jira issue searching UI to construct the subquery. That will ensure you get the correct syntax.

[Clark Everson]

Hi @JD 

Welcome to community!

ScriptRunner actually functions different on the data center and on the cloud. Can you add more details about your instance as it will influence how folks answer the question!

Best,

Clark