Application Event update IDO field

Legacy Contributor

Using the application event actions how do I update a row with a where clause?

For example, I am loading a IDO, I need to select a row where column a = 'a' update into column d value = 'd'

It is working to insert a new row, just cant figure out how to update an existing one. I would happily accept a point to the correct location in some documentation as well. 

dmitchell

I think there might be a couple ways of doing this, but we have used the combination of Load IDO Collection/UpdateCollection actions.

The Load IDO Collection action is used to filter to the row of data you want to update and placed into a Result Set.

Then tell the Update Collection action to use that Result Set for the update.



Note: The properties defined in both actions will not only need to consist of the property to be updated, but also the key property/properties for the record.