Fetching complete assignments using python

Question

Hello,

I'm using this python script:

https://github.com/Esri/workforce-scripts/blob/master/readmes/export_assignments_to_csv_readme.md

to export tasks to a CSV file.

I would like to use the

* -where <where> - The where clause to use when querying the assignments to export (Optional - Defaults to '1=1'

In order to filter only the completed tasks.

I could not find any documentation about the where clause.

Can someone please provide some explanation what are the possible value for this field?

Thank you

MaozTreeCare · Accepted Answer

Using this image

from

https://doc.arcgis.com/en/workforce/android-phone/help/workforce-schema.htm

I was able to figure out the status code for the completed tasks is 3.