I am trying to pull report with "Projecct Nam", "Created Dated", "Date first response". So when i put ......within the last 5 minutes then it shows 0 result i tried till 1 hour still zero. In general there is 100 tickets.
So is it querying all first time resolution in last 5 mins from current time withing the specific prject and date define ?
Isn't that the query should be straight forward of within 5 mins of any ticket created within the date range.
I am looking for all tickets which took more than 10 for first time response or before 10 mins within specific date.
Hello @Ranjith Parmel
Welcome to the Atlassian Community!
Jira does not have a system field called "Date first response", so I believe this is a date picker or date/time picker custom field you created to have the date where the first answer was added to the issue. Is that correct?
Additionally, I suppose that the "Created Dated" field is the system field "created" which is automatically filled with the issue creation date and time. Is that correct?
If that's the case, the JQL selected will consider the exact value added to the issue field and run it against the filter selected. Additionally, this time filter (within the last/More than) works in a different way for Date/time picker and Date picker fields.
Let me give you a practical example to better explain it:
The results of the query above will return the issue A, because the issue was created within the last 15 minutes (10 minutes ago) and the "Date first response" is a date picker field, so it will consider the current date select based on the time configured (Within the last 5 minutes, would consider the current date).
Let us know if this information helps.
Hi Atlassian Community! This is Teresa from the Atlassian team. My colleague Paul Buffington @Buff and I are excited to share a brand new ITSM resource we’ve created – "The Complete Guide to At...
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