Node Docker Paged queries for MSSQL

windows 10
Wappler 3.8.2

Cannot get paged query results.
first 10 records loads fine, but no more records i loading when you click on page 2.
Get this error “offset @p0 rows fetch next @p1 rows only - Invalid usage of the option next in the FETCH statement”.
complete error in attached filepagedgrid error.zip (615 Bytes)

Identical page in a php project against the same database works fine

Community Page
Last updated: