Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Creating a JQL Query that returns results based on history of tickets.

Hello All,


Continuing on from my first post I want to expand on my current JQL query to show the results based on historical data for example when a ticket was first created rather than last updated. 


For now, I've got "project = ABC AND issuetype in (Bug) AND updatedDate >= "2022-05-01 00:00" AND updatedDate <= "2022-05-01 23:59". "


This is working for now but the results could change without warning due to others working on them meaning that if I we're to run the JQL query on a Wednesday rather than a Monday, then the results may differ when for example I would want to see all the tickets created the previous week without returning the "last updated" time/date stamp


Is there a way I can search using the date a ticket was initially created rather than the date a ticket had been last updated, would it be a case of using a Join to pull in the history of the tickets? 

I've been trying to research this but I am unsure if this would physically work, any help would be gratefully appreciated.


Thank you.

1 answer

Hi @Lloydduckworth ,

created is date when the ticket is actually created. created date will not be updated. 

You can use below query


"project = ABC AND issuetype in (Bug) AND created>= "2022-05-01 00:00" AND created<= "2022-05-01 23:59". "

you can refer jira documentation regarding searching issues

Suggest an answer

Log in or Sign up to answer

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