Data tables with server side processing

sabu

I'm using jquery datatable in my project with Spring Mvc back end.I need to include alphabetical filter in my jquery datatable.I refer this page for alphabetical filter[https://www.datatables.net/blog/2014-09-22]. But this search is based on table loading data.I want to change this loading based search into server side.Thanks in advance..

allan

So you want to apply a where filter at the server side? If so, can you not simply modify your SQL (or whatever you are using to retrieve the data) to append the condition?

Allan

sabu

I modify my sql query with where condition,after getting the sorting data,the number of entries in the datatable not changed.

sabu

How to change the number of entries based on the filter data

allan

How to change the number of entries based on the filter data

What number of entries? The page length option? Can you please link to a test case showing the issue (per the forum rules).

Allan

sabu

showing entries

tangerine

Can you please link to a test case showing the issue (per the forum rules).

allan

I don't quite understand why would you want to change the page length based on the number of results in the table. Could you tell us why that would be? It could probably be done using the page.len() and page.info() methods along with the draw event, but I can't see why it would be something that would be useful I'm afraid.

Allan