I’m trying to work around the row limitation of 200 when using a SQL SELECT statement by using the OFFSET parameter and a custom state to enable paging.
My SQL statement works when I run it from Navicat and hit the MySQL db directly. But, Bubble is giving me a syntax error when I try using the parameters in the Plugin configuration. I tried several different combinations, without success. This includes trying to configure a parameter for the LIMIT value, which did not work either.
WHERE IFCLS = ?
All help is much appreciated.