I have a JQL query that uses the Search Linked Issues for JIRA plug-in to find all issues where the linked issues are all closed. The query takes an average of 55 seconds to run and might return < 100 records.
As you can see in my JQL, I have to exclude anything not closed, then include anything that's closed. Is there a way to optimize this query? Or maybe there's a more efficient plug-in I can use?
project = VMC AND issuetype = Feature AND fixVersion = "Release 2.4" AND issue not in linkedIssuesFromQuery("project = VMC and issuetype = Story and status in (New, \"In Progress\", \"In Testing\", Reopened, Completed)") AND issue in linkedIssuesFromQuery("project = VMC and issuetype = Story and status = Closed")
Thank you
I'm not sure if this will boost your performance, however I believe a "=" or "!=" is faster than an "in" operator. So you could try:
project = VMC AND issuetype = Feature AND fixVersion = "Release 2.4" AND issue not in linkedIssuesFromQuery("project = VMC and issuetype = Story and status != Closed") AND issue in linkedIssuesFromQuery("project = VMC and issuetype = Story and status = Closed")
You can achieve the same result via script runner plugin there I would use
project = VMC AND issuetype = Feature AND fixVersion = "Release 2.4" AND issuefunction in hasLinks("<YourLinkName>") and not issuefunction in linkedIssuesOf("project = VMC and issuetype = Story and status != Closed","<YourLinkName>")
But I don't know which would be faster.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.