AnsweredAssumed Answered

Survey123 Inbox Filter problems

Question asked by NEOMAPPER on Aug 1, 2018
Latest reply on Aug 1, 2018 by Philip.Wilson-esristaff

I am trying to get the Inbox filter to query data based on DISPATCHEDTO and CALLTYPE = 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 '40.615229 _-81.537074'?  

 

Tested and not working query
DISPATCHEDTO =${username} AND CALLTYPE = '40.615229 _-81.537074'

 

Survey Tab

 

Choices Tab

 

Outcomes