Query to get list of Jira projects using Jira-Bitbucket integration

[Suresh Mantrala]

Hi,

Our Jira (8.5.8) is integrated with Bitbucket. We are on Oracle DB. We are looking for a query (JQL) to find out which projects are using Jira-Bitbucket Integration in terms of

Which projects are using the integration for

1. Creating branches from Jira stories
2. Creating pull requests from Jira stories

Any help?

[Niranjan]

Hi @Suresh Mantrala ,

development[branches].all > 0

development[pullrequests].all >0

Ref article :https://confluence.atlassian.com/jirasoftwareserver085/advanced-searching-development-fields-reference-981156849.html