Find issues that are still open after 1 day and 14 days

Ankit Jain_tcwbnt

Hi

1.) I am trying to find out all Bugs/Incident with High/Urgent priority which are still open after 1 day, I am getting confusion in query 

created >= startOfDay(-1d) or created >= -1d are not same same thing?

what should be the query I should use (created one) condition I have told is to find out still open after 1 day rest query I figured out using AND

 

created AND issuetype in (Bug, Incident) AND priority in (High, Urgent)

John Funk

Hi Ankit,

It depends on the time of day when the issue was created as to which query will display the issue. I would use:

created >= startOfDay(-1) and statusCategory != Done and issuetype in (Bug, Incident) and priority in (High, Urgent)