Skip to Content (Press Enter)
Back to Ideas
16
Like
Follow Idea
Add Entity CRUD Operations that Accept Lists
514Views
6Comments
New
Database

I think there needs to be a built-in means of performing bulk CRUD operations on Lists in OutSystems.  If I have a list of records to delete, update or insert, I shouldn't have to use a For Each to loop over them and make multiple SQL requests.  These should be done with a single SQL statement without having to cobble that together in OutSystems in a very error prone way.  Other ORMs deliver this out of the box.  It's time OutSystems does the same.

13 Feb 2020
Copy link to comment

I believe OutSystems wants users to use the SQL widget for those cases. That way you only make a single SQL request as well.

14 Feb 2020
Copy link to comment

There's the "CreateOrUpdateAll" on Mobile. It could work similarly with Web. There's also a "DeleteAll", but that actually deletes all (i.e. clears the Entity), as opposed to "CreateOrUpdateAll" that takes a Record List.

14 Feb 2020
Copy link to comment

We are still on v10 on the Java stack (in the process of moving to .NET).  So the "CreateOrUpdateAll" doesn't exist for us.

14 Feb 2020
Copy link to comment

Like I said, this is Mobile only (sop also on P10), but it could work like that for Web.

14 Feb 2020
Copy link to comment

I think this should have more visibility because I find myself, especially when I need to process information from one system to another having the need to write DELETE statements. And this adds some overhead, which the platform should handle itself.

26 Feb 2021
Copy link to comment
2014-02-07 17-02-43
Vasco Pessanha
Changed the category to
Database
18 Mar 2021
Copy link to comment