Offset and Limit not removed when converting paged records to multiple records

Wappler Version : 4.9.1
Operating System : mac
Server Model: node
Database Type:
Hosting Type:

Expected behavior

When changing the Query Type from “Paged Records” to “Multiple Records” or “Single Record”, the limit and offset values should be removed.

Actual behavior

Offset and limit are retained on the query and thus change the behavior of the query.

How to reproduce

Created a paged query and set values for offset and limit

Screen Shot 2022-06-08 at 3.19.48 PM936×576 27.2 KB

Change to Multiple records:

Screen Shot 2022-06-08 at 3.20.25 PM910×798 34.7 KB

And then look in code view to see values persit

Screen Shot 2022-06-08 at 3.21.01 PM578×540 28.3 KB

Running the query will also show the limit and offset are applied.