topic Re: Querying a feature layer based on date? in ArcGIS Survey123 Questions

Querying a feature layer based on date?

bsklaohfl — Fri, 28 Apr 2023 14:10:38 GMT

Using Survey123 Connect, is it possible to query a feature layer based on a dateTime field? I've been trying this, but have not had any luck.

Re: Querying a feature layer based on date?

IsmaelChivite — Fri, 28 Apr 2023 17:08:32 GMT

Below is an example: Configures the Inbox to retrieve only records where the date value in the install_date column is now older than a week from the current date.

Re: Querying a feature layer based on date?

bsklaohfl — Fri, 28 Apr 2023 17:43:10 GMT

Thank you for responding. Can this feature be used for a pulldata getRecord calculation?

Re: Querying a feature layer based on date?

IsmaelChivite — Mon, 01 May 2023 00:49:14 GMT

I realize now that you seemed to be asking a different question originally. Sorry for the guessing.

To your question: Yes, the pulldata getRecord operation allows you to query date fields. Essentially, any WHERE statement you can pass to a feature layer, is supported in the pulldata getRecord operation.

For example:

pulldata("@layer","getRecord","<yourlayerURL>","RECDATETIME BETWEEN CURRENT_TIMESTAMP - 7 AND CURRENT_TIMESTAMP")
pulldata("@layer","getRecord","<yourlayerURL>","RECDATETIME BETWEEN DATE '2023-04-27' AND DATE '2023-04-29'")

Check the Date and Time format section of this help topic for details on the date queries you can make to an ArcGIS layer: https://developers.arcgis.com/rest/services-reference/enterprise/query-feature-service-layer-.htm

Important consideration:

ArcGIS stores date values in UTC.
The pulldata() get record operation returns only ONE record.