How to navigate 200 row limit?

Looks like Bubble limits SQL results to 200 rows, but I have thousands of rows that I want to search and filter over. Is that possible to do on Bubble?

Ok with displaying < 200 results at a time, but need a way to be able to search and filter over the entire thousand+ rows.

You can do this with looping.

1st loop you will get 200 records the call next loop.
2nd loop you have received 200 records then call 3rd loop otherwise skip looping.

@mani2726 that makes sense! What’s the best way to implement looping? Assuming it’s not in my SQL query? I’m new to Bubble, appreciate your help

Pass the param of limit and offet to myself and get the list of data. This looping need to implement on bubble backend workflow.

Where you able to solve this?