How to query for all commits/PRs underneath a Jira Epic?

Question

We have Jira & GitHub integration. Commits have already been labeled to auto-associate them to Jira tickets & subtasks.

I'd like to query for all of them via the one epic issue that ties all the issues together.

The closest I've gotten is a flattened list of issues/subtasks with commits:

issue in portfolioChildIssuesOf(EPIC-1234) and development[commits].all > 0

Can I get the list of commits directly? (Once I do, I'll filter via git for the ones that've actually been merged. I suppose conversely, I can look up for commit messages matching the flattened list of issues/subtasks.)

Earl McCutcheon · Answer

Hello @Kevin C ,

In Jira JQL you can search for issues that are tied to the development tools where a commit is present as you have done with the search you noted, and you can find more information about searching the development fields here, Advanced search reference - JQL developer status.

However you cannot search for the values of the commits linked to a specific repository, that information is not stored in the fields Jira side and you would have to look in bitbucket.  You could possibly use the Bitbucket REST API to get the values from the commit messages out. Some more details can be seen in this thread:

* https://community.atlassian.com/t5/Bitbucket-questions/Bitbucket-Cloud-REST-API-to-list-all-commit-messages-between-two/qaq-p/676759

Regards,
Earl