Inbox Query Help

[NatalieSlayden]

I am having trouble with a Query to pull surveys to an inbox.

What I have working is: It pulls the form based on the user, if the form is incompleted, and if diseased acroporids =0.

Creator=${username} AND EntryComplete IS NULL AND DiseasedAcroporids=0

How I want it to work is: It pulls the form based on the user and if the form is incomplete. Plus if diseased acroporids =0 or if diseased massives =0. 

So if Diseased acroporids is 1 and massives is 0, I do not want the form to pull into the inbox even if the form is incomplete. 

I was hoping to just add an OR but It does not work :

Creator=${username} AND EntryComplete IS NULL AND DiseasedAcroporids=0 OR DiseasedMassives=0

Any suggestions?

[NatalieSlayden · Accepted solution]

I figured it out: 

Correct Query is 

Creator=${username} AND (EntryComplete IS NULL AND DiseasedAcroporids=0) OR (EntryComplete IS NULL AND DiseasedMassives=0)