topic Re: Survey123 Inbox Filter problems in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/survey123-inbox-filter-problems/m-p/772726#M4241 <HTML><HEAD></HEAD><BODY><P>Hi Jordan,</P><P></P><P>Are you able to provide a copy of your xlsx form and the exact query and fields you are trying to use for the where clause query. Based on your screenshots the field name and lookup value you are trying to query is LEAKFOUND, but in the where clause you have&nbsp;<SPAN style="background-color: #ffffff;">CALLTYPE field name? Am I missing something?</SPAN></P><P></P><P><SPAN style="background-color: #ffffff;">Phil.</SPAN></P></BODY></HTML> Thu, 02 Aug 2018 00:22:59 GMT Anonymous User 2018-08-02T00:22:59Z Survey123 Inbox Filter problems https://community.esri.com/t5/arcgis-survey123-questions/survey123-inbox-filter-problems/m-p/772725#M4240 <HTML><HEAD></HEAD><BODY><P>I am trying to get the Inbox filter to query data based on DISPATCHEDTO and <SPAN>CALLTYPE&nbsp;</SPAN>= 40.61522 _-81.537074 but I can't get the sql query to actually work. I don't get any errors when I re-download the survey and open the inbox. Does it not like the string? Is it maybe possible to write a SQL expression where CALLTYPE IS NOT 'Y' AND 'N' and we can assume it chooses everything else which would be the this string '<SPAN>40.615229 _-81.537074</SPAN>'?&nbsp;&nbsp;</P><P></P><P>Tested and not working query<BR />DISPATCHEDTO =${username} AND CALLTYPE = '40.615229 _-81.537074'</P><P></P><P><STRONG>Survey Tab</STRONG></P><P><IMG class="image-3 jive-image" src="https://community.esri.com/legacyfs/online/416685_pastedImage_3.png" /></P><P></P><P><STRONG>Choices Tab</STRONG></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/416680_pastedImage_1.png" /></P><P></P><P><IMG class="image-2 jive-image" src="https://community.esri.com/legacyfs/online/416684_pastedImage_2.png" /></P></BODY></HTML> Wed, 01 Aug 2018 13:57:39 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-inbox-filter-problems/m-p/772725#M4240 JordanMiller4 2018-08-01T13:57:39Z Re: Survey123 Inbox Filter problems https://community.esri.com/t5/arcgis-survey123-questions/survey123-inbox-filter-problems/m-p/772726#M4241 <HTML><HEAD></HEAD><BODY><P>Hi Jordan,</P><P></P><P>Are you able to provide a copy of your xlsx form and the exact query and fields you are trying to use for the where clause query. Based on your screenshots the field name and lookup value you are trying to query is LEAKFOUND, but in the where clause you have&nbsp;<SPAN style="background-color: #ffffff;">CALLTYPE field name? Am I missing something?</SPAN></P><P></P><P><SPAN style="background-color: #ffffff;">Phil.</SPAN></P></BODY></HTML> Thu, 02 Aug 2018 00:22:59 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-inbox-filter-problems/m-p/772726#M4241 Anonymous User 2018-08-02T00:22:59Z