Filter for Issues with open pull (or merge) requests

Question

Jira Data Center 9.0.0

Git Integration for Jira 4.4

Gitlab Enterprise Edition 14.10.5-ee

Self-managed/hosted on a closed, classified environment

I am trying to come up with a filter to return issues in Jira with open pull (or merge) requests.  I came across issue.property[development].openprs but though I see issues with merge requests marked as OPENED, the filter "issue.property[development].openprs > 0" returns nothing.

The filter "issue.property[development].openprs = 0" returns all the issues including those with OPENED merge requests.

Question: Is "issue.property[development].openprs" not what I think it is?  Or does it not work with Gitlab?

I have looked through many documents like https://confluence.atlassian.com/adminjiraserver0900/integrating-with-development-tools-1142254676.html and https://confluence.atlassian.com/jirasoftwareserver090/viewing-the-development-information-for-an-issue-1142452089.html.  Note that the first link mentions Gitlab amongst other dev tools but the second link does not mention Gitlab though it listed all the others.

I came across development[pullrequests].open but the Advanced search field marks it as invalid once I type the "[" after "development".

Boyd K · Answer

Tried development[pullrequests].open > 0.

But the results were not as desired.

We are integrated with Gitlab.

A few Jira issues have an opened merge requests.  But the above query does not return them.  They do return with all the other issues if the filter using = 0 instead.

Lisa Förstberg_ov9lib · Answer

Hi!

Maybe this page will help more: https://support.atlassian.com/jira-work-management/docs/advanced-search-reference-jql-developer-status/

I think this should do the trick:

development[pullrequests].open > 0

good luck

/Lisa