Forums

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

Please review my JQL for creating a filter that shows bugs created in the last 24hrs

Otto
Contributor
February 12, 2018

Hi Helpful Atlassian Community,

 

I'm trying to create a filter that shows bugs created in the last 24 hours. And I am completely new to JQL:

project = SEED AND issuetype = Bug AND status in ("Claim Fix", "Fix Failed", "Fix Verified", "In Progress", "Need More Info", Open, Reopened)  AND createdDate IS (+24h)

The createdDate IS (+24h) is where the problem seems to be. The rest of the filter works separatedly.

 

Thanks for the help!

2 answers

1 vote
Charly [DEISER]
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.
February 12, 2018

Hi @Otto

Try with: createdDate >= -24h

Cheers

Otto
Contributor
February 12, 2018

Gracias! Thanks a lot!!!! it works!
Just out of pure curiosity, this would mean the filter would count 24 hours back every time the filter is looked at?

Charly [DEISER]
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.
February 12, 2018

Yes it will count 24 hours back every time and display only the issues that met this criteria.

If you need a different approach you can also use some of the provided JQL functions like 

startOfDay() or endOfDay() described here:

https://confluence.atlassian.com/jirasoftwarecloud/advanced-searching-functions-reference-764478342.html

ie: Find new issues created since the start of yesterday:
created > startOfDay("-1")

As you can see there are many possible solutions depending on your needs.

Otto
Contributor
February 12, 2018

Perfect! thanks a lot @Charly [DEISER]

1 vote
Nic Brough -Adaptavist-
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.
February 12, 2018

+24h means 24 hours in the future.  Try -24h

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events