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!
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).