How to find Issues with Merged PR

[Fabian E_]

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?

[Nic Brough -Adaptavist-]

This was fixed 5 years ago by using the correct username. 

Another client of ours had usernames with non-Roman characters in them which failed because they had not got the database collation set correctly, so that is worth checking if you are having this problem

[Marynel]

Having a similar issue

[Ricardo Araya]

Still no answer???
We have the exact poblem

[Anthony Van Alphen]

I have the same issue on import of custom user picker. Still looking for answer

[Jacqueline Miller]

Did you ever figure out this issue? I'm experiencing the exact same thing!