Search pane with server-side processing showing "No data available"

DeepaLatha

Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem: We want to load 10 set of data from DB to UI datatble( rather than fetching entire data from db ,which leads performance issue & latency issue) through server side pagination

e.g: : DB has 40 records, but we only fetching 10 rows along with the totalrow count(40) to respresent server side pagination

(Note: in server side processing datatable- Sorting and loading 10 set of rows we handled via Database Stored procedure)
**
Actual Issue:**: But when we try to use searchPanes and show the 10 set of data in it, data is not binding and showing empty searchPanes with " NO DATA AVAILABLE" message.

we have gone through the soultion which was posted in this site ,( in that they loaded entire data in searchPanes which again leads to "performance issue" and cause latency ) or if we take serverSide:true and change serverSide:false --> searchPane data loading properly but again we can't achieve server side- processing pagination )

Please help us to resolve this ASAP

kthorngren

Sounds like your server script might not support SearchPanes as described in the SearchPanes SSP docs. This blog explains how to use the Editor server side processing libraries to support SearchPanes.

Kevin