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.
Hi @Lloyd ,
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
https://confluence.atlassian.com/jirasoftwareserver/searching-for-issues-939938681.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.