Forums

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

JQL query - fetch list of issues based on status

shrishail pragun
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!
November 12, 2024

Hello,

Request help to write a query to fetch the list of issues created on the previous day

1 answer

2 votes
Tansu Akdeniz
Community Champion
November 12, 2024

Hi @shrishail pragun 

Welcome to the community.

It shows issues created yesterday.

created > startOfDay(-1) AND created < endOfDay(-1)

Please also check this JQL functions page.

You can add "status = XXX" to the query if needed.

Suggest an answer

Log in or Sign up to answer