Development Reporting

[Kelly Hawke]

I'm trying to help a team report on 'Branches', 'Commits' and 'Pull Requests' within JIRA (all appear under the Development section).

Tickes are in a non-agile project and developers use BitBucket to manage the code.

Looking for a way to report\track within JIRA.

Any ideas?

[Mikael Sandberg · Accepted solution]

You can use JQL to query on the development information using these searches:

• development[pullrequests].all (or .open)
• development[commits].all
• development[reviews].all (or .open)
• development[builds].failing

You cannot search based on the branch, at least not yet.

[Kelly Hawke]

Thanks!  Can you give me an example of a basic query (to get the context)...

[Mikael Sandberg]

This query will get you all issues in the project that has at least one pull request associated with it:

project = JRA AND development[pullrequests].all > 0

[Kelly Hawke]

Thank you!!!!  This helped.  I'm a novice coder :-)

[Muhammad Ramzan_Atlassian Certified Master_]

you can use JQL Search Extensions for Jira & reports  to get all results .

CommitsCount

Search for issues that have particular number of commits. This value is present if JIRA is connected to Bitbucket or Crucible/Fisheye.

commitsCount > 0

FailingBuildsCount

Search for issues that have particular number of failed builds. This value is present if JIRA is connected to Bamboo. 

failingBuildsCount > 0

OpenReviewsCount

Search for issues that have particular number of open reviews. This value is present if JIRA is connected to Bitbucket or Crucible/Fisheye.

openReviewsCount > 0

PullRequestsCount

Search for issues that have particular number of pull requests. This value is present if JIRA is connected to Bitbucket. 

pullRequestsCount > 0

ReviewsCount

Search for issues that have particular number of reviews. This value is present if JIRA is connected to Bitbucket or Crucible/Fisheye.

reviewsCount > 0

CommitsCount

Search for issues that have particular number of commits. This value is present if JIRA is connected to Bitbucket or Crucible/Fisheye.

CommitsCount

Search for issues that have particular number of commits. This value is present if JIRA is connected to Bitbucket or Crucible/Fisheye.

These are examples, you can play with the queries as per your requirements.

Reference:

https://jqlsearchextensions.atlassian.net/wiki/spaces/SEARCH/pages/30497099/JQL+Reference+Server#JQLReference(Server)-SoftwareDevelopment