Finding tickets closed with no commits

[Dominic Hurst]

I want to get stats on dev subtasks closed with no commit. Our way of working is that a dev must use the ticket ref when making a code change related to that ticket. 

I want to get stats to find out how often this is not happening.

Thanks

Dominic

[Muhammad Ramzan(Atlassian Certified Master)]

I think with default queries its not possible to get the issues as you want. I am using following plugin to get those stories or tasks where no code commit is done. in your case following query will work.

issuetype in (standardIssueTypes(), subTaskIssueTypes()) AND Sprint in (434, 464) and statusCategory = Done and commitsCount <=0

You can change the above query  as per your need, main parameter you need to change is 

to get commit count > 0
commitsCount > 0

to get commit count =0
commitsCount = 0

You can use more queries like below

ailingBuildsCount

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

failingBuildsCount > 0

Documentation is available here

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

[Randy]

statusCategory = Done and development[commits].all > 0

[Dominic Hurst]

Hi 

Many thanks for your reply but its not working with my wider query, I am asking for tickets with no commit in x sprints 

issuetype in (standardIssueTypes(), subTaskIssueTypes()) AND Sprint in (434, 464) and statusCategory = Done and development[commits].all > 0 ORDER BY key ASC, Rank ASC