topic Get the most recent date with a pulldata in ArcGIS Survey123 Questions

Get the most recent date with a pulldata

Polesig — Thu, 06 Jul 2023 16:52:28 GMT

I want to set up a form that allows to control the vegetation on plots. A plot can be checked several times during the year.
When collecting a new survey I would like to retrieve the date of the last control carried out on the plot with a pulldata on the feature layer of the form itself, like this:

pulldata("@layer","getValueAt","attributes.date_collecte",${feature_layer_id_parcelle},${Location})

My questions:
Can I know the last date of passage on a plot that has been visited several times? Can we do calculations in a pulldata ?

Can the pulldata query the form service itself? I think so, it's a service like any other.
Besides, it makes me think that this method can be used if you want to do an incrementation on continuous numbering like tree numbering (pulladat + 1)
So can we imagine making a

…,”attribute.max(value),”…

Thank you for your many feedback..

PoleSIG

Re: Get the most recent date with a pulldata

IsmaelChivite — Thu, 06 Jul 2023 21:54:42 GMT

I think this could be done by adding extra parameters to the URL as described in the Request Parameters section of this help topic.

For example:

pulldata("@layer", "getValueAt", "attributes.dateCollected", "<yourFLURL>/0?orderByFields=dateCollected DESC&resultOffset=1", ${Location})

Note that the URL includes a ? sign and then extra parameters to refine the query: sort by date in descending order and return only one record. That would give you the record with the most recent dateCollected date.

Hope this helps.

Re: Get the most recent date with a pulldata

BNix_TPA — Thu, 04 Apr 2024 13:04:57 GMT

HI,

I'm using the example you published above, but it doesn't seem to be pulling the most recent record, it pulls the second oldest record. If I drop the resultOffset=1, it pulls the oldest record instead of the newest. Below is what I have in my spreadsheet:

pulldata("@layer", "getValue",

"attributes.inspection_date","https://services5.arcgis.com/YTApDBs0YanBdxkq/arcgis/rest/services/service_d05d28403a9d4482a58f367dc2b9ef43/FeatureServer/0?orderByFields:inspection_dateDESC&resultOffset=1", ${where2})

${where2} = concat("asset_id = '", ${asset_id}, "'")