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

Community
Q&A
Jira
Questions
Search for all issues where all linked issues are closed

How to disconnect JIRA-bot from Slack channel?

I want to delete JIRA-bot from the member of a Slack channel.

I have removed JIRA App and also removed the configuration. However, JIRA-bot is not kicked out from Slack channel.

How to disconnect JIRA-bot from Slack channel?

1 answer

1 accepted

3 votes

Answer accepted

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.

Comment

Thank you. I used the script runner solution and it ran in seconds. Thank you!

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks for the clear comment @Udo Brand

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Forums

Q&A

Community resources

Support

Top groups

Community resources

Support

Learn

Community resources

Support

Events

Community resources

Support

How to disconnect JIRA-bot from Slack channel?

1 answer

1 accepted

Suggest an answer

Was this helpful?

Thanks!

TAGS

Community showcase

Atlassian Community Events