CreateorUpdate Action Functionality

CreateorUpdate Action Functionality


I consider myself relatively new to OutSystems, hence this kind of question.  I would like to know if the CreateOrUpdate or just the Update Actions will actually perform an update on data when there is no technical change in the data.  I'm currently checking for any changes in the data before the CreateOrUpdate and Update Actions to prevent any unnecessary transactions on the database.

Hi Jay,

It always does a query in the database. 

There are some optimizations if the platform is able to detect that there are no changes to the attributes (and in the Advanced options of the entity the "Update Behavior" is set to "Changed Attributes").

But if no attribute was changed, a query that sets one of the attributes to the same value will be executed, to ensure that any database triggers still run if necessary.

João Rosado