Forums

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

How to write a query to retrieve the defects raised for the day?

Selvalakshmi Suyambulingam
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!
July 18, 2023

I want to get the list of defects raised today.

3 answers

2 votes
Tim Perrault
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.
July 18, 2023

Hi @Selvalakshmi Suyambulingam 

 

Below is the basics of what you would need. From there you can expand the query, but below will get you everything created from the start of the day.

 

created >= startOfDay() 
1 vote
Laurie Sciutti
Community Champion
July 18, 2023

Hi @Selvalakshmi Suyambulingam ~ welcome!  This should work:

 

issuetype = Defect and created >= startOfDay()

0 votes
Bill Sheboy
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.
July 18, 2023

Hi @Selvalakshmi Suyambulingam -- Welcome to the Atlassian Community!

In addition to the posts of example JQL for your question, please review this free training and documentation to help create queries like you asked about.

https://university.atlassian.com/student/path/849533-gain-project-insights-through-jql

https://support.atlassian.com/jira-software-cloud/docs/use-advanced-search-with-jira-query-language-jql/

Kind regards,
Bill

Suggest an answer

Log in or Sign up to answer