Massive Create, Update or Delete

Massive Create, Update or Delete

  

Hello community,


Does Outsystems allow to create, update or delete massively through a list, for instance, using the action inside the entities (e.g., CreateEntity, CreateOrUpdateEntity) instead of having to create a for loop and create, update or delete record per record?


Thank you,

Rafael Valente

Solution

Hi Rafael,

For massive create, you can use the BulkInsert forge plugin, 

For massive delete you can use the SQL widget. For instance: "DELETE * FROM {xxx}" to delete all records of an entity

For massive updates you can also use the SQL widget, but this is very limited. For instance: "UPDATE {xxx} SET {xxx}.IsActive = 0" to disable all records in an entity.

Kind regards,

Remco Dekkinga

Solution