How do I update a set of records using a Modify Data process element?
I have a configuration item with a number of children. All the configuration items (parent and children) are associated with an Account in the CI User table. I am writing a business process to transfer all configuration items from one account to another.
In SQL, I would do something like this:
Update CI User
Set Account =
Where Configuration Item in (Select ID from Configuration Item where Parent CI = )
In the Process Designer, I tried using a Read data process element to read the IDs of all the children Configuration Items, but when I try to reference those IDs in a Modify Data process element, it will not let me select any fields for that Configuration Item.
Maybe this is a basic question, but how do I update a set of records using a Modify Data process element?
Like
Dear Bob,
Unfortunately, there is no way to process set of records at once in business process. The way it can be performed is to create a cycle reading element one by one using some flag to not to read one element several times. Aldo you can use SQL Executor (free app on our Maretplace https://marketplace.bpmonline.com/app/pt-sql-executor-bpmonline) to execute your scripts or execute them in configuration.
Best regards,
Dennis