CodeIgniter JQXWIDGETS

Hi,


Thank you for your suggestions, it makes me see what I might be doing wrong.


The problem is on my SQL query. It is not getting all the results. It just gets the results with the limit and offset applied.

Here is my new query. Hope it helps someone:

Code:

SELECT
 CustCode as customerCode,
 CustNm as customerName,
 overall_count = COUNT(*) OVER()
FROM BigEMasterData.dbo.tbl_Customers
ORDER BY CustCode
 OFFSET @PageNum ROWS
 FETCH NEXT @PageSize ROWS ONLY;