SQL Code for the Paged Query is missing LIMIT & OFFSET parameters

Wappler General Bugs
#1

Wappler Version : 5.5.3
Operating System : MacOS
Server Model: NodeJS
Database Type: MSSQL
Hosting Type: Docker

Expected behavior

What do you think should happen?

When selecting the Query Type as Paged Records, the SQL Code is expected to add LIMIT and OFFSET parameters to the SQL code.

Actual behavior

What actually happens?

  1. There are no LIMIT and OFFSET parameters. This is the code being generated in the Query Builder.
  2. A Multiple Records query type cannot be converted to Paged Records query - same issue with the code as above

select [customer_id], [customer_code], [customer_abn], [customer_name], [customer_trading_name], [customer_email], [customer_phone], [customer_terms], [customer_lastsaledate], [customer_status] from [dbo].[customers] order by [customer_code] ASC, (select null)

#2
#3

When there are no values for the offset and limit those will not show in the sample sql. If you specify different test values they will.

#4

Oh, I see. I thought they were always included in the SQL Code. Sorry for my misunderstanding.

#5