Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JQL to find tickets which have commits after the ticket has moved to "in testing"

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

1 answer

1 accepted

1 vote
Answer accepted

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:

https://support.atlassian.com/jira-software-cloud/docs/automate-your-jira-cloud-processes-and-workflows/


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

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:

  1. Save the most recent commit datetime triggered on commit for an issue
  2. Save when an issue transitioned to "in testing", triggered on transition
  3. Report on any thing committed after the transition, triggered on a schedule or manually

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!

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Posted in Jira Software

Presenting the "Best of 2020" Jira Software roundup!

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 ...

7,071 views 8 28
Join discussion

Community Events

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

Events near you