We're using Jira with Bitbucket hooked up to it.
Is it possible to use JQL to find all Jira tickets which have a bitbucket commit after the ticket has been in a specific status e.g. "in testing"
Thanks in advance
Hi @Gemma Pitman -- Welcome to the Atlassian Community!
Looking at the documentation for advanced queries, I do not believe that you can get the commit datetime currently: https://support.atlassian.com/jira-core-cloud/docs/advanced-search-reference-jql-developer-status/
Perhaps there is a marketplace add-on for query scripting that would help find prior occurrences of commits.
In the meantime, if you want to track this condition going forward you could add an automation rule, triggered on a commit and check the status for specific values you wanted to note.
Please see this documentation to learn about the automation rules:
Glad to hear that.
Even if the commit date isn't available after event occurs, you could save the most recent commit datetime in a custom field and use that to compare to when an issue transition to "in testing". That could solve your query issue. It will probably take three rules to do it:
Please consider marking this one as answered if this one ends up working for you. This will help others in the community find solutions faster. Thanks!
@Bill Sheboy Is there any way to get commit ids for particular Jira Ticket?
Please answer my question:
Catch up with Atlassian Product Managers in our 2020 Demo Den round-up! From Advanced Roadmaps to Code in Jira to Next-Gen Workflows, check out the videos below to help up-level your work in the new ...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events