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

[Ankit Jain]

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)