JSQL query

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

1 answer

2 votes

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

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.