Filtering for recently updated issues not working

[Gusztáv Jánvári]

Guys, I have this search query (to list all undone issues, plus those entered specific other states in the last 2 weeks):

project = QA 
AND 
(
   statusCategory != Done 
   OR 
     (
       status in (Cancelled, Closed, Done) 
       AND 
       updated > "-2w"
     )
) 
ORDER BY updated ASC, Rank ASC

Why do I get issues last updated 6 months ago? Very interestingly, if I change the > operator to <, I get old issues as well. I can't find what I do wrong. Could you help?

Gusztáv

[Alexey Matveev]

You will get issues, which are update 6 months ago for the "statusCategory != Done" condition. If you want to limit such issue you should write:

project = QA 
AND 
(
 (  
 statusCategory != Done  
   AND
 updated > "-2w"

)
 OR 
 (
 status in (Cancelled, Closed, Done) 
 AND 
 updated > "-2w"
 )
) 
ORDER BY updated ASC, Rank ASC

[Gusztáv Jánvári]

Thanks for the response, Alexey! Actually I want to list all undone issues, so I don't need the limit for when statusCategory is not Done, only for the specified states.

I think my expression says this: list things from the QA project, which:

• are either not done
• are either in one of the 3 specified states and were updated in the past two weeks

Yet the results show cancelled and done issues updated months ago.

[Alexey Matveev]

Your query looks correct. Try to reindex your project.

[Gusztáv Jánvári]

Reindexing is not possible in the cloud, and the query is still returning issues last updated in last August. :(