topic Survey123 inbox query show records when a field has no value in ArcGIS Survey123 Questions https://community.esri.com/t5/arcgis-survey123-questions/survey123-inbox-query-show-records-when-a-field/m-p/792961#M8624 <HTML><HEAD></HEAD><BODY><P>How do I show surveys where the reviewed by field is blank or NULL? We want to let our managers to be able to see work that's not been signed off by someone. Thanks!</P><P></P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/410547_pastedImage_1.png" /></P></BODY></HTML> Mon, 04 Jun 2018 13:31:29 GMT JordanMiller4 2018-06-04T13:31:29Z Survey123 inbox query show records when a field has no value https://community.esri.com/t5/arcgis-survey123-questions/survey123-inbox-query-show-records-when-a-field/m-p/792961#M8624 <HTML><HEAD></HEAD><BODY><P>How do I show surveys where the reviewed by field is blank or NULL? We want to let our managers to be able to see work that's not been signed off by someone. Thanks!</P><P></P><P></P><P><IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/410547_pastedImage_1.png" /></P></BODY></HTML> Mon, 04 Jun 2018 13:31:29 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-inbox-query-show-records-when-a-field/m-p/792961#M8624 JordanMiller4 2018-06-04T13:31:29Z Re: Survey123 inbox query show records when a field has no value https://community.esri.com/t5/arcgis-survey123-questions/survey123-inbox-query-show-records-when-a-field/m-p/792962#M8625 <HTML><HEAD></HEAD><BODY><P>I found my solution. Below I will list the query and link.</P><P></P><P>REVIEWEDBY IS NULL</P><P></P><P><A class="link-titled" href="https://www.w3schools.com/sql/sql_null_values.asp" title="https://www.w3schools.com/sql/sql_null_values.asp">SQL NULL Values - IS NULL and IS NOT NULL</A>&nbsp;</P></BODY></HTML> Mon, 04 Jun 2018 13:56:14 GMT https://community.esri.com/t5/arcgis-survey123-questions/survey123-inbox-query-show-records-when-a-field/m-p/792962#M8625 JordanMiller4 2018-06-04T13:56:14Z