JQL to find the issues that have code commits

[Kota Sreenivasa Shravana Kumar]

Hello,

Is there a way to have a JIRA query (JQL) to find the list of issues that has code commit associated with it ? 

Please advise. 

Thanks !

[Aida Real · Accepted solution]

This works for me: development[commits].all > 0

[Jeremy]

This worked for me. None of the others did. Thanks, Aida!

[Fowler]

This works for me as well - please update this to be the "accepted" answer. Maybe the old syntax, `issue.property[development].commits > 0` worked in older versions, but this seems to be the syntax for "current" (as of Feb 2018) for JIRA Cloud.

Many Thanks!!!

[Christian Sakai]

Where did you find this in the docs?

[Magdalena Michalak]

It's here: https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-fields-reference-939938743.html

[Aida Real]

Not really, I found it in StackOverflow I think. Fortunately, the docs are updated now and they are more complete than ever ;)

[zuck3rman]

development[commits].all > 0  - perfect, thanks a lot!!!

[Adam Wride]

Note that as of today (September 16, 2019):

development[commits].all > 0 

works only for Classic Jira projects. NextGen projects do not appear to support this JQL feature.

[Aida Real]

Thanks for the update Adam!

[sgautrin]

@Magdalena Michalakas of today (2019-09-19) at least, it is not in the page you linked: that page has no reference of either “property”, “development” or “commits”.

Additionally, the `development[commits].all > 0`  query works (at least for classic jira projects), but is marked by jira as invalid (red cross instead of green check), and prevents JQL autocomplete from working if you want to add other criteria.

Edit: found it in the documentation in another page I found via a thread linked to this one: https://confluence.atlassian.com/jiracorecloud/advanced-searching-developer-reference-967312946.html

[Dibyendu Mukherjee]

This document is not accessible, it's not opening. Issues are not having property called development...

[Magdalena Michalak]

@sgautrin Sorry, it seems that the info was moved to a separate page and is now here: https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-development-fields-reference-973491363.html

[Adina Simu]

@Magdalena Michalak The page you've indicated covers Bitbucket, Bamboo, Crucible; is Github supported? I am seeing weird behavior when querying for "development[commits].all > 0" in my Jira instance with Github integration. 

[Casey Maynard]

My apologies for the noobness of the reply.

I am looking for a JQL query that will list the branch that was referenced in a Git Commits (or Git Roll Up). 

The "development[commits].all > 0" does not seem to pull any results.  My guess is I need to refine the criteria, but it is not clear where I should begin.

BTW: We use the JIRA server, not a cloud version.

And please no Add-on solutions, as Add-ons are not affordable nor sustainable over the longer term of our projects.

[Adam Wride]

Hi @Casey Maynard -

I see you are looking for a Jira native solution - but I see you mentioned "Git Roll Up" issue tab which is specific to the Git Integration app that we make. Do you have that app installed?

[Casey Maynard]

My guess is Yes we have Git Roll Up (is GIT Commit also part of this same Git integration app?) installed in JIRA.  I am familiar with GIT usage, as I am mainly the Confluence person, but my team needs a way to track the GIT commits and merging branches into master all of the Commit branches for a specific Epic(s).

[Adam Wride]

Hi Casey -

Yes, the Git Commit issue tab and Git Roll Up issue tab are both from the same Git Integration app. The latest version is v3.4.3.

The app has two options for JQL searching (for Jira Server and Data Center):

gitCommitsReferenced

gitBranch

Examples:

gitBranch in (master) AND resolution = Unresolved 

gitCommitsReferenced is not empty AND resolution = Unresolved

More documentation: https://bigbrassband.com/git-integration-for-jira/documentation/jql-searching.html

Note: there is a hard limit currently on JQL searching of 65,000 Jira issues with commits. We'll be addressing this limitation later this year.

If you have any specific follow up questions - you can reach us at support@bigbrassband.com

Cheers,

Adam

[Chris McGuire]

@Adam Wride I see that this article only references Jira Server.  Is there a JQL method for Jira Cloud? 

[Chris McGuire]

@Adam Wride This article appears to only be applicable to Jira Server.  Is there a method for JQL queries in Jira Cloud? 

[Adam Wride]

Hi @Chris McGuire -

Indeed - the above article is for Jira Server/Data Center.

For Jira Cloud - you can reference this article: JQL searching for commits and pull requests

[Chris McGuire]

Thanks for the quick reply, @Adam Wride   Unfortunately, using the method described on this page does not seem to be helping (ie. development[commits].all > 0).  I'm curious - does the following option have to be enabled in order for this to work properly? 

"Send Development Information to Jira Cloud"

[Adam Wride]

Hi @Chris McGuire -

Correct, you will need "Send Development Information to Jira Cloud" enabled (which is the default for new installations - but if you installed the app more than a few weeks ago - you'll need to enable it in the General settings of the app).

Note: you will likely want to reconnect your repositories/integrations after enabling that setting so that all the commits/branches/pull requests get included.

[Shadd Schutte]

You can find the development functions for JQL at the url below it all depends if you have your dev tools linked to Jira.

https://confluence.atlassian.com/jirasoftwareserver/advanced-searching-development-fields-reference-973491363.html

[Rose Cruz]

@Tobias Schönit's jql worked for me. Thanks!

issue.property[development].commits > 0

[CSaxon]

Perfect!   Thanks this works wonders!

[Gonchik Tsymzhitov]

Thank you for your jql request!

[crf]

I believe you can do this with JQL.  Try adding "issue.property[development].commits is not empty" to your query.

[Kota Sreenivasa Shravana Kumar]

Thanks for your immediate help. Query does not yield any results. I am trying the following in JQL. Is there anything wrong ? project = "Advanced Planning" and issue.property[development].commits is not empty No issues were found to match your search Try modifying your search criteria or creating a new issue

[crf]

It would rely on on you having set up the integration between JIRA and your source control system. The information for that JQL comes from the same source that makes the number of commits and branches show up in the developer status area. See these two links: * https://confluence.atlassian.com/jira/integrating-jira-with-code-development-tools-395707042.html#IntegratingJIRAwithCodeDevelopmentTools-Developmentpanelonissues * https://confluence.atlassian.com/jira/streamlining-your-development-with-jira-443548553.html

[crf]

However, it's also worth noting that this information is updated rather lazily, as well. See this answer for a bit more about this: https://answers.atlassian.com/questions/20644626/answers/21631644

[Kota Sreenivasa Shravana Kumar]

There is already a integration setup between our STASH and JIRA instance.

[Moshe E]

Works for me when I use equals, greater or less combination. However, it did not work with is or is not empty. 

[Tobias Schönit]

It should be 

issue.property[development].commits > 0

[Kota Sreenivasa Shravana Kumar]

It does not work for me. It says, No issues were found to match your search

[April]

I think the trouble you're having might be the > displayed here; probably different browsers render this page differently.

For Jira, that should be changed to the 'greater than' symbol, like this:

issue.property[development].commits > 0

[Vaibhav Parikh]

not working for me. Are there any special settings to get it worked?

[Fowler]

@Vaibhav Parikh: Check out the response from @Aida Real above and try `development[commits].all > 0`

[Vaibhav Parikh]

Thanks Patrick. That worked.. I was trying with issue.property[development].commits. Great help.. thanks

[Peter Kahn]

Looks like JQL changed at some point

This works well

development[commits].all > 0

 Anyone know how to limit that to a specific branch... like master?

[Gonchik Tsymzhitov]

Yeah, the function was changed. Let's check feature request in jira.atlassian.com