How to loop through all rows in a database table?

Data Service
1

I have two tables. private_properties and developers.

private_properties table has 2800 rows. I want to loop through all the rows in the table to update a developer column in the private _properties table. This update will create relationship between private_properties and devlepers table. I have all the logic in place and it is working good.

Right now when I load table objects using UI builder, it allows me to load and update only 100 rows.

How do I loop through all the 2800 rows in the private_properties table?

2

Hello @Jag_Karnan

You need to use paging functionality to get the next 100 records until you processed all your items.
Take a look at the post that describes how to load all records How to set pageSIze > 100 in the "Load Table Objects" block - Knowledge Base - Backendless Support

Regards, Vlad