Why do Queries with created >= -7d not return results?

Philip Lucks

I had a query setup 3 weeks ago which mysteriously stopped working.  

 I am looking for Open Bugs, created in the last week (7 days) that have a CustomList field (text) that is not empty:

project in (DEV, GEN) AND issuetype = Bug AND resolution = Unresolved AND "Customer List" is not EMPTY AND created >= startOfDay(-7) ORDER BY priority DESC, updated DESC

It seems that the use of a time frame AND created >= startOfDay(-7) now returns no results.  Did something change since I last captured data on Monday? 

 

unknown

Hi @Philip Lucks

If this query has worked in the past, and you are running it again, some of the issues from your earlier run may not have been caught because they are past the created in the last 7 days criteria you have, provided all the other criteria from your JQL are still met. I know you have mentioned that the created >= startOfDay(-7) might be the cause. Have you tried creating a new issue meeting all the other requirements from the JQL (created criteria will be met because you are creating it now) and see if it shows up in the JQL result ?

 

Thanks

Kalyani