Filtering for recently updated issues not working

Question

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

unknown · Answer

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

Alexey Matveev · Answer

Your query looks correct. Try to reindex your project.

unknown · Answer

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.