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; } } }

How to find tickets in a particular state "at" a specific date ?

Anjana Rajendran

I need to find the tickets, which are in a particular status (say in 'Committed', 'Submitted) with a particular group of people, at a particular "date and time".

Below is the case :

Tickets that are in status (x,y,z) ON Jan 31st with people (a,b,c,d)

Can you please help me with a JQL Query ?

Accepted answers

Boris Georgiev [Appfire]

You can use the following :

status was in (x,y,z) ON 2014-04-15

I just do not get what "with people" means ? Is this assignee or something else ?

If you mean assignee just use one more "was"

status was in (x,y,z) ON 2014-04-15 and assignee was in (admin, john) ON 2014-04-15

All comments

Boris Georgiev [Appfire]

You can use the following :

status was in (x,y,z) ON 2014-04-15

I just do not get what "with people" means ? Is this assignee or something else ?

If you mean assignee just use one more "was"

status was in (x,y,z) ON 2014-04-15 and assignee was in (admin, john) ON 2014-04-15

Tiago Comasseto

Hi Anjana, not sure if I understood it rigth, but may this JQL helps you:

status in (Open, Resolved) AND assignee in (user1, user2) AND updated = "2014/01/31"

You may also take a lot at this doc to see what operations are supported via advanced search.

Cheers

Fabio Racobaldo _Catworkx_

Hi Anjana,

did u try using DURING? Example : status was 'Open' DURING ('2010-01-01','2011-01-01')

Hope this helps.

Fabio

Anjana Rajendran

Thankyou Fabio. Problem in using this query is that, I am not looking for a closed duration, but for specific dates. Basically at the end of each month I need to know the open tickets with assignee (x,y,z)

Anjana Rajendran

Thanks Boris, That helped :-)

Anjana Rajendran

Thankyou Tiago. Problem in using this query is that, the ticket can be updated by 'anyone' (need not be assignee)

Boris Georgiev [Appfire]

Would you mark my answer as accepted please ?

Anjana Rajendran

I clicked on the tick mark against your answer. Is that all I need to do ? Sorry, am new to Atlassian forum.