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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.