parentehsis in jsql question

[Aleksander Zmorzyński]

Hey. I need a query that will show me change requests with priority blocker and bugs with priority blocker and critical. also Id like to see only issues NOT in status done, rejected or canceled. 

I wrote something like this
issuetype = "Change request" AND priority = Blocker OR issuetype = Bug AND priority = Blocker AND priority = Critical AND status not in (Done, Rejected, Canceled) 

But I think it wont work as intended.. I cant put whole issuetype in parenthesis, so how would I make such a query? :(

[Thomas Schlegel · Accepted solution]

Hi @Aleksander Zmorzyński,

this should do it:

((issuetype = "Change request" AND priority = Blocker) OR (issuetype = Bug AND priority in ("Blocker, Critical))) AND status not in (Done, Rejected, Canceled)

[Aleksander Zmorzyński]

Thanks ! I missed one parenthesis when I was trying myself :)

[Thomas Schlegel]

You're welcome, @Aleksander Zmorzyński

[Aleksander Zmorzyński]

Okay, one more question. Any idea why when I save

((issuetype = "Change request" AND priority = Blocker) OR (issuetype = Task AND priority = Blocker) OR (issuetype = Bug AND priority in (Blocker, Critical))) AND status not in (Done, Rejected, Canceled) ORDER BY priority DESC

Jira removes parenthesis on issuetypes ? so when I open the saved query again I get

(issuetype = "Change request" AND priority = Blocker OR issuetype = Task AND priority = Blocker OR issuetype = Bug AND priority in (Blocker, Critical)) AND status not in (Done, Rejected, Canceled) ORDER BY priority DESC"

is this giving me the same results ?