Need JQL to find issues with AT LEAST one pull request and AT LEAST one MERGED pull request.

Question

Folks,

I'm trying to create a JQL query that will return issues that have the following:

* AT LEAST one (1) pull request
* AT LEAST one (1) MERGED pull request

AND development[pullrequests].all > 0 AND development[pullrequests].open < 1

I was using the above, however that means if I have multiple pr's on an issue it won't return if even one is open.

Does JIRA support something akin to "development[pullrequests].merged >= 1??

Christian_u2uxo9 · Answer

If found this answer to a similar question that showed me how to filter on pull requests and their status.

https://community.atlassian.com/t5/Jira-Software-questions/How-to-find-Issues-with-Merged-PR/qaq-p/830999

NOTE: There is a difference between JIRA Server and Cloud editions!

Philip Schlesinger · Answer

See https://jira.atlassian.com/browse/JRACLOUD-60724 -- and please vote!

Philip Schlesinger · Answer

I have the same request and will bump thread. Did anybody find how to resolve this issue w/o having to pay for JQL Search Extensions?