nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need help with JQL in finding issues that has been created 4 hours ago and no assignee

vihar garlapati

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.

Accepted answers

All comments

Nic Brough -Adaptavist-

Your > is the wrong way around, it's saying "created in the last four hours". I think you want "updated < -4h" - that will give you all unassigned issues that have not been updated (including created) recently.

somethingblue

Hi Vihar,

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.

Cheers,

Branden

vihar garlapati

Thanks Nic for the quick reply. Sorry I did not frame my request right.

The ask is :

1) Need a JQL to list all the tickets that have been created 4 hours ago and no assignee

vihar garlapati

Thanks Brandan for the quick reply. Sorry I did not frame my request right.

The ask is :

1) Need a JQL to list all the tickets that have been created 4 hours ago and no assignee

vihar garlapati

Something wrong with my query. Am trying to get the tickets created 4 hours ago with no assignee and status not closed, am seeing the tickets from yesterday also for some reason.

Below is the query

project = IT AND created < -4h and Status != Closed

Nic Brough -Adaptavist-

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?

vihar garlapati

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira