I'd like to find all open issues that have a merged PR in order to find tickets that might have been forgotten to be resolved and therefore will probably ship to production untested.
JQL has the two terms `development[pullrequests].open` and `development[pullrequests].open`, but unfortunately no means to filter out `declined` PRs. So when I do `status not in (Closed, Resolved) AND development[pullrequests].all > 0 AND development[pullrequests].open = 0`, I will get both issues with `merged` and `declined` PRs. I'd like to only get the ones with `merged` PRs.
Is that possible somehow? If not, could this be added to JQL?
For Jira Software Server 7.8+ you can find the full list of available development fields here - https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-fields-reference-939938743.html
To find all the issues only with merged pull requests I recommend using the following filter:
development[pullrequests].merged > 0 AND development[pullrequests].open = 0 AND development[pullrequests].declined = 0
@Tony Sullivan The list of fields available in Jira Cloud is different from Jira Server.
As of May 2019, Jira Cloud doesn't support development[pullrequests].merged field.
Here is full search reference for Jira Cloud - https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-developer-reference-967312910.html
It seems like this behaviour matches what is described on the following feature request (this is the Jira Server version):
If that's the case, feel free to comment on the feature request to share with the Jira team the use cases for this request.
Caterina - Atlassian
When to use CSV importer When managing your processes in Jira, there are many occasions where you need to create a lot of tasks. Creating them one by one will cost you a lot of time and effort and i...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events