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
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
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:
Yet the results show cancelled and done issues updated months ago.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Your query looks correct. Try to reindex your project.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Reindexing is not possible in the cloud, and the query is still returning issues last updated in last August. :(
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Manage Confluence like never before! This new learning path teaches you how to manage content, users, and permissions while optimizing user experience. Built for admins at all levels who want to confidently lead and unlock more innovative collaboration.
Learn more
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.