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?

[pkirkeby · Accepted solution]

You can integrate OnDemand with Google Apps as explained here:

https://confluence.atlassian.com/display/AOD/Integrating+OnDemand+with+Google+Apps

Cheers!

[Andrey Kolpakov]

Seems, it is not working anymore. Can you suggest a new solution?

[Sorin Sbarnea]

This requires you to connect your ENTIRE Google Apps domain to JIRA and Confluence, which will probably explode the licensing costs as you will be forced to pay a license for every Google Apps account.

[Webrepublic AG]

Hi, this article says that only onDemand instances that include JIRA can have Google open authentication (oauth).

We don't need JIRA. Is there still a way we can use Google Apps oauth v2 with two step authentication with onDemand Confluence only?

All the best

Mario