Hi,
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:
Best regards,
Bill
Thank you Bill, I will take a look at the automation documentation to see if there's anything I can use there.
Thanks,
Gemma
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Bill Sheboy Is there any way to get commit ids for particular Jira Ticket?
Please answer my question:
https://community.atlassian.com/t5/Jira-Software-questions/Is-there-any-way-to-get-commit-hash-codes-for-particular-ticket/qaq-p/1602844
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @ankit45621
Sorry, I do not know that. I suggest waiting to see if the person from Atlassian who responded has more information. If you do not hear anything back for a while, consider submitting a support ticket for help.
Best regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.