Automation: Move ticket when all PRs are closed

[Conrado Fonseca]

Greetings 🖖

We are looking to automate the move of a ticket to a certain board column when all PRs have status closed.

I added this `development[pullrequests].open = 0` as JQL condition but it's not working 100% and I'm starting to think that need to add another condition to the JQL to match the current issue but couldn't find a way to compare the issue key.

The audit says:

JQL condition
The following issues did not match the condition:

[John Funk]

Hi Conrado - Welcome to the Atlassian Community!

Why do you have a check on the issue key? It is already only dealing with a single key. I would take that part out and see if it works for you. 

[Conrado Fonseca]

Hi John, thanks for the fast response.

I was actually not checking for the issue key and I started to use it because sometimes the automation was not working properly with just (sometimes id did work)

development[pullrequests].open = 0

and the audit showing 

The following issues did not match the condition. 

Is there a better way to check if all PRs are closed ?

[John Funk]

Thanks for the clarification. I would run the query in JQL advance search to see if it returns a value there. Modify as necessary until you get the results you expect to see, then paste it back in the rule. 

[Conrado Fonseca]

I have one issue with a single PR merged 

But when search for:

issuekey = <ISSUE_KEY> AND development[pullrequests].open < 0 

I get that No issues were found to match your search
 

[John Funk]

Merged and Open are not the same status for pull requests. Merged is not Open. 

And you can't say < 0 - that won't return you anything. You can use > 0 

[Conrado Fonseca]

You are right, sorry, it was a typo. I was actually using an equal comparator.

Just found that this condition works only for issue type Bug, I'm able to get the proper results with:

issuetype = Bug AND development[pullrequests].all > 0 AND NOT development[pullrequests].open > 0

but not with any other issuetype value, think that is the reason the JQL is failing in the automation.

Removing the issue type, it just returns Bugs, there are any other kind of issue type being listed. 

[John Funk]

What's another issue type that would apply? And have you run the query just for that issue type? (Replacing Bug with that issue type).

[Conrado Fonseca]

Task is another issue type. Going to attach some images to add more context to the issue.

Filter all Bugs with PR condition

Filter all Tasks without PR condition, it's possible to see that the selected issue have a PR merged.

Filter all Tasks with PR condition, no issues listed

[John Funk]

That's very baffling!  I would open a support ticket with Atlassian.

https://support.atlassian.com/contact/#/

Please post the solution back here so we can close this one out.