Workforce Assignment Where Clauses, Delete Assignments Older Than a Month

RobertAnderson3

I've been working with the ArcGIS Online hosted Notebooks to create and modify assignments in Workforce. I've managed to get it to do a fair bit of what I'd like but the one spot I seem to keep struggling is the syntax for the where clauses when I want to use a field other than "status" as the sample notebooks have it.

Of particular interest would be working with the assigned worker (workerid) and then the date fields. I just can't seem to figure these ones out.

The date clause would be super useful to set up a way to delete assignments that are older than a month.

Any help would be appreciated!

Anonymous User

It looks like it's mixing field types, if status is 1 (int), but then it is setting to a string 'Declined'? is that field set with a domain?

The loop is a little odd too, since you get a list of features that match the query and then for each one redo the search to grab the first one returned. Why not query once and iterate the results:

assignments = project.assignments.search(where="status=1")
for feature in assignments:
    feature.update(status="Declined",declined_date=datetime.datetime.now(), declined_comment="Weekly Timeout of Assignment")
    print(feature)

 
If you wanted to use another field:

assignments = project.assignments.search(where="fieldname=1234")
for feature in assignments:
    feature.update(status="Declined",declined_date=datetime.datetime.now(), declined_comment="Weekly Timeout of Assignment")
    print(feature)

 

Doing the last month filter is a little tricky because on the first of each month would mean the items older than a day. If you run this daily, the first day of the month change over will remove everything in the previous month.  Maybe go by a 30 day block?  Items older than 30 days will be removed?