Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

how to query for date greater the suppose 23rd march

Suhas
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 2, 2020

 

I want to do advance search for satus updated after some date

assignee =b78 and status = Done and updated <(some date ex 20th March)

1 answer

1 accepted

0 votes
Answer accepted
Daniel Ebers
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 10, 2020

Hi Suhas,

welcome to Atlassian Community!

assignee = b78 AND status = Done AND updated > "2020/03/20 00:00" AND updated < "2020/04/10 00:00"

The above JQL query will show issues which have been updated between 20 March 2020 and 10 April 2020.

I hope it helps.

Cheers,
Daniel

Suhas
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 10, 2020

Thanks Daniel for the reply, I was able to get what i want. Could you suggest any videos dedicated to query only, which would help me filter better.

Daniel Ebers
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 10, 2020

Sure! Glad you were able to find what you were looking for.

For JQL I recommend Atlassian Training (https://training.atlassian.com/Jira-basics). If you don't want to enroll the Training there is also some content on JQL on Atlassian's YouTube channel (https://www.youtube.com/user/GoAtlassian/videos).

Cheers,
Daniel

Like Suhas likes this

Suggest an answer

Log in or Sign up to answer