Limit and Offset for Dataviews
Update limit and offset support in the SOAP compatibility service DataviewServiceImpl
.
- Assure there is at least the
order by 1
in the SQL - Extend
ORDER BY Id
part of the SQL withOFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY
Also update the code to check for sqlEngine
and apply OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY
when sqlEngine == "sqlserver"
, for others append LIMIT 100 OFFSET 50
.