How to copy assignments to another feature class with Python script?

LaneHartman — Fri, 31 May 2019 20:56:24 GMT

I'm attempting to use the copy_assignment_to_fc.py script found on GitHub to copy assignments earlier than a certain date to a separate feature class. The script keeps getting hung up on the "-where" parameter. So I keep getting errors saying it cannot perform query. Invalid query parameters. I need some direction on the format of that portion I guess. Below is what I've tried without success. Aaron Pulver

-where "completedDate <= DATE '02/01/2019'"

-where "1=1"

The attached screenshot is of the Python Command Prompt using the "1=1" argument.

Thanks!

Re: How to copy assignments to another feature class with Python script?

Anonymous User — Tue, 04 Jun 2019 00:33:45 GMT

It looks like it's actually failing to query the target features. If you look at the script it's calling

target_fl.query(out_fields=field_mappings[project._assignment_schema.global_id])

You may want to check your field mappings to make sure it's correct. It queries to get all of the global ids (so it doesn't duplicate any features).

topic How to copy assignments to another feature class with Python script? in ArcGIS Workforce Questions

How to copy assignments to another feature class with Python script?

Re: How to copy assignments to another feature class with Python script?