topic Re: Survey123 Inbox bind::esri:parameters query syntax in ArcGIS Survey123 Questions

Survey123 Inbox bind::esri:parameters query syntax

BrentKinal1 — Thu, 02 Jul 2020 14:58:57 GMT

I have been trying to build a query so the inbox only returns repeat records from a date field(${travelDate}) 10 days or less from the max date (${maxTravelDate} which equals max(${travelDate})), or this could be records dated the 10 days or less from the current date. I would also like to return repeat records from the current month. I can't seem to dial in the syntax any of these queries. The Prepare for editing existing survey data—Survey123 for ArcGIS | Documentation doesn't cover this, nor can I find any good resources on developing query syntax for this. I have tried several iterations of query syntax with out success and was wondering if this is even possible or if I am traveling down a rabbit hole with no end?

Re: Survey123 Inbox bind::esri:parameters query syntax

Anonymous User — Wed, 05 Aug 2020 02:13:26 GMT

Hi Brent,

Can you provide the exact query you are trying to use? And a copy of your xlsx form so we can try to do further testing?

I am not sure this type of complex query is supported due to recent changes to AGO which do not allow non Standardized SQL expressions. Only standard SQL expressions can be used, so if the expression requires non-standard operators, it will not work.

Regards,

Phil.

Re: Survey123 Inbox bind::esri:parameters query syntax

MichelleWilliamsERM — Fri, 30 Dec 2022 22:26:40 GMT

Did you figure this out? I liked your complexity of yours and could see it being useful.

I have a few I'm working through today - without success.

bind::esri:parameters below

query=afterCountPhoto<>NULL

query=afterCountPhoto<1

query=afterCountPhoto>1

query=afterCountPhoto<>null

query=afterCountPhoto!=null