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

[Daniel Gallegos]

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??

[Daniel Turczanski - __JQL Search Extensions]

Hi!

JQL Search Extensions has JQL keywords for pull requests. Documentation can be found here.

After installing the plugin you can check the number of pull requests:

pullRequestsCount > 0

As well as open pull requests:

openPullRequestsCount >0


[Christian]

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]

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?

[Philip Schlesinger]

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

[Timofey Murzin]

I have the same request and will bump thread. Daniel - did you find how to resolve this issue?

[Daniel Gallegos]

Bump.