jql either or but not both

[ShannonW]

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]

In cloud think you will have to do it like:

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

[ShannonW]

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]

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) )