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

Question

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!

copy_assignment_to_fc error.PNG

Capture.JPG

MichaelGould_0-1648541368072.png

Anonymous User · Answer

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