Limit Offset

[dmdahlan]

Pak, limit offset tidak bisa digunakan

[poetrasapoetra]

Hello @dmdahlan,
If you use limit in builder it will not work because datatable will replace limit using request from datatable client (pagination and page size select).
You can set datatable option to set manually

let tableInstance = new DataTable("#myTable", {
     serverSide: true,
     processing: false,
     lengthMenu: [20, 25, 50,100], // menu for pagination page size (limit and offset)
     pageLength: 50, // default value used when DataTable initialize
     ....
})