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 0

Like

1 comments

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

Show all comments