I have successfully connected my SQL database using the connector plugin. I have multiple tables with more than 200 records (Bubble’s limit) and I am able to bring those in using the SQL query with LIMIT but I can’t seem to use any other query to bring in all the records in batches.
for example, I have the following:
This works just fine but I have more than 200 records. I have tried many different SQL queries but no matter what I try, I get the Bubble error saying there are more than 200 records.
So what I need to be able to do is query to get records 1-200 then 201-400, etc. How can I do this?