Bulk update/delete

Unknown

Ability to update and delete records without looping would be great.  Basically, instead of querying first then loop through each record, be able to specify what fields to be updated based on a set of conditions.

Doing so will eliminate the steps to transform records from the query into a list of objects, then performing operations on them.  It will just be one database operation, which is much quicker.

Michael Udinski

These functionalities are already in the pipeline. I'm not sure exactly how they are being designed but a bulk delete and bulk update should be coming

Bryan

Does this actually increase the speed? Apart from making it easier for us users, I'm guessing behind the scenes, it's still looping, and updating/deleting one by one?

Unknown

Normally, I'd just issue the SQL statements directly from the code:  

update user set reference='xyz' where first_name like '%jake%'

The SQL can be constructed dynamically based on the parameters.  If all this can be done at the database level, then, yes, it will be faster.  There's no round trip concern between the code and the database layers.

Jhon Michael Revilla

Hi @Michael Udinski . update on this? thank you! :)

Ray Deck

Hey @Jhon Michael Revilla the functionality for bulk insert (add) was released in Xano this summer. Updates (edit) are still one-at-a-time.

Shirley

Hello. Any update on this ? Thanks

Bas van Ginkel

Just adding my 5 cents to this. ;)

Would love to see something like this.

Orbiter

Any chance we will get bulk EDIT and bulk DELETE soon @Michael Udinski ??