I am trying to put together a query in JIRA that covers the following criteria:
I wondered if someone can point me in the right direction please?
Hi @Colin Young
JQL is not a SQL, so you cannot compare different fields within a single query as you ask with out-of-the-box Jira: e.g. resolved within N time units of created.
To do that you would need a marketplace add-on for JQL to enhance the query or an improved reporting tool, or you could try these work-arounds:
Thanks again Vikrant.
I think I need to avoid using static dates. The main idea is to get tickets that were closed last month and within 24 hours of them being created.
I can create the query that shows all tickets from current month -1. I just can't get the closed within a day part of it :(
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