Update object

The Update object action updates the object class properties of objects in a data source.

Usage

This action node is used to update properties on one or more objects in a data source.

To update many objects at once (a batch update) there are two possible methods:

Use a While or Foreach action node to iterate over the objects. Add an Update object action node inside the iterator action node with the same data source selected and Object in context as the Selection.
Use only the Update object action node. This method is more performant. See the example Batch update in the Examples section below.

When Update object operates on an object it becomes the object in context. This object in context contains the original values prior to the update and these can be accessed using data bindings and functions.

In addition, the values set in the update are available as self-properties. Self-properties are only available in functions. These can be used to update properties that are dependent on the values of other properties that are being updated in the same operation. In other words, a function must be used to access to new value of a property, if that property is updated in the same Update Object operations. See the example Update Object - Self Properties and dependencies below.

Examples

In this example, 1 object is updated. The properties Price and Product (reference) of an Order line is updated. As you see, the Price on the Order line is set equal to the price of the Product.

You may use the value processor inside the Update Object action node. For example, to increase a value by 1.

Imagine the following simple scenario. You want to set Property 1 to 20, and you want to set Property 2 equal Property 1 in the same Update Object operation

In the above example: if both Prop 1 and Prop 2 was 0 by default, then Prop 2 will still be 0 after this update. The reason is that Data Binding defaults to the old value of the bound property. If you want to access the new value, you must use a function, and add prop1 from the Self Properties list, as illustrated below:

In the function editor, as in the screenshot above, you may expand the data source in the left pane and add the same property as a function parameter from there. That will imply use the old value, and not the new value (self-property). Note that you may only add properties directly at the data source itself as self-properties, and not reference properties (e.g. if you are updating Order Line.Product and Order Line.Price in the same operation, you cannot select Order Line.Product.Product Price as self-property)