JSQL query

Anni R

Hello!

Why is it so - that my query shows issues with Closed status, but it shoud'nt. Syntax != "Closed" means NOT EQUALS ("!=") and must be not showed.

status != "Closed" AND watcher = currentUser() OR reporter = currentUser() OR assignee = currentUser() ORDER BY status DESC, key DESC

But this query works as needed.

status != "Closed" and Suund = Tehniline ORDER BY cf[10081] ASC, key DESC

Nic Brough -Adaptavist-

I think your clauses are being read (correctly) in a way you're not expecting.

Try

status != "Closed" AND (watcher = currentUser() OR reporter = currentUser() OR assignee = currentUser() ) ORDER BY status DESC, key DESC