Hello,

I am trying to move a list of users in a user reference field to another user reference field as part of a rule. I plan on using this functionality as a workflow tool to indicate who has been assigned the node that the reference field is attached to. I am attempting to have the first field function as an "assign to" field and the second field as a "assigned to" filed. My idea is to use rules to transfer the list of users from one field to another upon node save/edit. I have attempted to accomplish this using two approaches, both without success (described below) and was hoping that I am making a mistake here - and this is not a rules issue:

Approach 1:
-Loop over the first reference field
-Fetch user ID
-Add user ID to second reference field.

Issue: this results in a "PDOException: SQLSTATE[23000]: Integrity constraint violation..." error.

Approach 2:
-Create view of the relevant users that includes a contextual filter for the node, and a VBO field
-Create a rule with a "load a list of entity ids from a VBO View" and use the view create in step 1, using a node:nid argument.
-Set value action using the entity id list - targeting the second user entity reference field

Issue: the set value action does not recognize the list from the view as valid for the target field.

Could anyone provide guidance on how to resolve the issues with either approach?

Many thanks.