Inbox Query Help

323
1
Jump to solution
12-08-2022 08:43 AM
NatalieSlayden
New Contributor III

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?

0 Kudos
1 Solution

Accepted Solutions
NatalieSlayden
New Contributor III

I figured it out: 

Correct Query is 

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

View solution in original post

0 Kudos
1 Reply
NatalieSlayden
New Contributor III

I figured it out: 

Correct Query is 

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

0 Kudos