Fetching complete assignments using python

103
1
Jump to solution
08-18-2022 02:31 AM
MaozTreeCare
New Contributor II

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

0 Kudos
1 Solution

Accepted Solutions
MaozTreeCare
New Contributor II

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.

View solution in original post

0 Kudos
1 Reply
MaozTreeCare
New Contributor II

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.

0 Kudos