How to build a JQL query with if statement

Question

Need to filter all bugs - excluding some Held reasons I have on bugs in status on hold.

problem is - when the bug moved to closed status, held reason is still populated and the filter is excluding those bugs.

we need to exclude the bugs with specific held reasons only when in status "on Hold"

keren yerushalmi · Answer

Ok, Thanks Dave

Dave Bosman _Inetum_ · Answer

You need to rewrite your query.

Basically, create a query for everything exept for your exeption.

A second query for your exception

And then combine them (each query in brackets ( ) ) with  an or statement between them.

Regards

Dave

keren yerushalmi · Answer

Thanks Dave for the quick replay

but it doesnt solve my issue, I need  - to exclude the held reason only when status is on hold, but that the filter will include all statuses

this is the query i did - but it is wrong it is not excluding the bugs with held reason i wanted to exclude

project = CMAEGON AND issuetype = "Customer Bug" AND "Project Stream" in ("EB – Unisure", "All") AND ("Held Reason" not in ("Awaiting Customer Retest", "Awaiting Customer WG Decision", "Awaiting for CR", "Customer Info Awaited", "Pending Customer Approval", "Rejected Candidate") OR status in (Open, "In Analysis", "In Review", "IN PROMOTION", "In Test", "On Hold", Closed, "Ready To Promote",REJECTED))