topic delete records older than 1 month in ArcGIS Workforce Questions

delete records older than 1 month

Anonymous User — Mon, 09 Jan 2023 15:53:48 GMT

Is there a quick way to select all records that are older than 30 days? I'm hoping to use model builder to select all Completed records that are older than a month and delete them from my dataset. I prefer to use model builder so that I can set it and forget it! Any ideas would be appreciated.

Re: delete records older than 1 month

MichaelVolz — Mon, 09 Jan 2023 17:21:23 GMT

First off, do you have a Date field in your data that would allow a query to select all records where that date is at least 30 days from current date?

Re: delete records older than 1 month

Anonymous User — Mon, 09 Jan 2023 18:41:56 GMT

No I do not have a field like that. I used an Arcade expression to calculate the Assignment due dates (a pothole is identified in the field and the date it needs to be filled by is based on the road classification) and was hoping that I would be able to use another Arcade Expression/SQL statement to select points with a Completed date that is at least 30 days from today's date.

Re: delete records older than 1 month

RobertAnderson3 — Wed, 15 Feb 2023 14:06:06 GMT

I was just coming looking to resolve the same problem, though I was hoping for a Python solution in ArcGIS Online Notebooks instead of ModelBuilder.

From Michael's question though, if you're using Workforce then when a user completes the assignment there is a field in the Assignments layer already that would capture the completed date and time "completeddate"! Then you could find a way to compare today's date to that date field.

Schema for Workforce can be found here: https://doc.arcgis.com/en/workforce/android-phone/help/workforce-schema.htm