Subjects says it all.
Neeed help with JQL to find issues that were created 4 hours ago and yet no assignee yet.
Am trying this query but not workin.
project = IT AND assignee is EMPTY and created > -4h
Your help is greatly appreciated. Thanks in advance.
No, there's nothing wrong with your query. The query is looking for issues that were created "before (now - 4 hours)", or in English "more than 4 hours ago". That means *Everything* over 4 hours old.
I think the problem is that your question is not right.
When you say "Need a JQL to list all the tickets that have been created 4 hours ago and no assignee", you are not defining the time range usefully.
"created 4 hours ago" is not a range. It's an absolute. Let's say I create an issue at 16:32:04. The only time "created 4 hours ago" is going to find it is when it is 20:32:04. That's a window of one second where the query works.
Which I don't think is what you really want? Could you give us what you are really looking for? Explain "created 4 hours ago" in full?
Sure, I will try to be precice. Lets say a ticket IST-1 is created at 2 PM and is not assigned to anybody for more then 4 hours. At 6 PM or little after 6 PM, if I run the query, IST-1 should come up in search result because that ticket was created 4 hours ago and not assigned to any one. Does it make sense ?
To be more precise, I have a add-on that runs at intervals and I have to feed that add-on with the query to search and return the tickets that have been created 4 hours ago and not yet assigned. Why 4 hours ? 4 hours is the SLA that somebody has to take take up that ticket. Nobody taking a taking a ticket and if it is beyond 4 hours, the add-on would pick the ticket up and alert us.
Hope am clear with my question :) .. Sorry if am adding more confusion
No, that's fine, it is clear, thank you. The extra background of the requirement (the "why I want this") is also helpful too!
My question came up because you said "am seeing the tickets from yesterday also for some reason". That's correct, you will see them because they are over 4 hours old and not assigned to anyone.
Here is my final query.
Ask : Search and return all the tickets that has been created 4 hours ago from the current time. Lets say a ticket has been created at ABC-1 at 9 AM, ABC-2 at 9. 30 AM, ABC-3 at 10 AM and if I run this query at say at 4 PM and imagine these tickets are not assigned, when I run the below query , should return ABC-1, ABC-2,ABC-3 .
project = ABC and updated < -4h and assignee is EMPTY and status != Closed.
Do you think it will work ?
I used the same query and got the results I expected. I had a project (HELLO WORLD) that had issues from days ago. I created two new issues and ran the following:
project = HEL and assignee is empty and created > -4h
I verified the results by running
project = HEL and assignee is empty
The above returned all of my issues which was expected.
At this point I would try re-indexing and retrying the query to see if you get different results.
This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.Read more
Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs