https://community.esri.com/t5/arcgis-survey123-questions/inbox-query-help/m-p/1239206#M46416 <P>I am having trouble with a Query to pull surveys to an inbox.</P><P>What I have working is: It pulls the form based on the user, if the form is incompleted, and if diseased acroporids =0.</P><P>Creator=${username} AND EntryComplete IS NULL AND DiseasedAcroporids=0</P><P>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.&nbsp;</P><P>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.&nbsp;</P><P>I was hoping to just add an OR but It does not work :</P><P>Creator=${username} AND EntryComplete IS NULL AND DiseasedAcroporids=0 <STRONG>OR DiseasedMassives=0</STRONG></P><P>&nbsp;</P><P>Any suggestions?</P> Thu, 08 Dec 2022 16:43:45 GMT NatalieSlayden 2022-12-08T16:43:45Z https://community.esri.com/t5/arcgis-survey123-questions/inbox-query-help/m-p/1239206#M46416 <P>I am having trouble with a Query to pull surveys to an inbox.</P><P>What I have working is: It pulls the form based on the user, if the form is incompleted, and if diseased acroporids =0.</P><P>Creator=${username} AND EntryComplete IS NULL AND DiseasedAcroporids=0</P><P>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.&nbsp;</P><P>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.&nbsp;</P><P>I was hoping to just add an OR but It does not work :</P><P>Creator=${username} AND EntryComplete IS NULL AND DiseasedAcroporids=0 <STRONG>OR DiseasedMassives=0</STRONG></P><P>&nbsp;</P><P>Any suggestions?</P> Thu, 08 Dec 2022 16:43:45 GMT https://community.esri.com/t5/arcgis-survey123-questions/inbox-query-help/m-p/1239206#M46416 NatalieSlayden 2022-12-08T16:43:45Z https://community.esri.com/t5/arcgis-survey123-questions/inbox-query-help/m-p/1239232#M46418 <P>I figured it out:&nbsp;</P><P>Correct Query is&nbsp;</P><P>Creator=${username} AND (EntryComplete IS NULL AND DiseasedAcroporids=0) OR (EntryComplete IS NULL AND DiseasedMassives=0)</P> Thu, 08 Dec 2022 17:18:46 GMT https://community.esri.com/t5/arcgis-survey123-questions/inbox-query-help/m-p/1239232#M46418 NatalieSlayden 2022-12-08T17:18:46Z