jql either or but not both

Question

I would like to show results if Approved is yes or no and Data is yes or no, but do not show if the answer to both is yes.

project = "SPECS Production" AND issuetype = "Email/E-News" AND status = "In Progress"  AND Approved in (yes,no) OR "Data Complete" in (yes,no) AND NOT "Data Complete" = Yes AND Approved = Yes

JamieA · Answer

If you're not sure about operator precedence use parens:

status = "In Progress" AND (
	(Approved = Yes AND "Data Complete" = No) OR 
	(Approved = No AND "Data Complete" = Yes) OR 
	(Approved = No AND "Data Complete" = No)
)

ShannonW · Answer

Thank you @Jamie Echlin [Adaptavist]. That works, any ideas why Status is being ignored? This is what I'm using:

status = "In Progress" AND (Approved = Yes AND "Data Complete" = No) OR (Approved = No AND "Data Complete" = Yes) OR (Approved = No AND "Data Complete" = No)

JamieA · Answer

In cloud think you will have to do it like:

(A = Yes and B = No) or (A = No and B = Yes)