bSortable_(int) & bSearchable_(int) - Server Side Processing

JNT

Hello,

I've implemented Server Side Processing and I was expecting to see the bSortable_(int) & bSearchable_(int) parameters sent to the server as described here: http://www.datatables.net/usage/server-side . They don't ever seem to be included in the request though. Is there anything special I need to do to get those in the request?

Thanks!

allan

It's sSortable_(int) and sSearchable_(int) - i.e. s prefix (string), rather than b (boolean): http://datatables.net/development/ . They should be included always (I don't think you can switch them off...), and you should see them go out if you use Firebug or something like that.

Allan

emjay2

In 1.6.1 I do see bsearchable_int and bsortable_int

in 1.5 (they didn't seem to be there yet.)

I don't have any between installed

allan

I do apologise! Sorry - there was an error in the documentation. I've now corrected this. And yes, I think I introduced these somewhere along the line in the 1.5.x series. Good to here it's all sensible in 1.6 and the docs are now right :-)

Regards,
Allan

JNT

Makes sense, I'm using an older version...

Thanks!

NJDave71

Allan:

I am using firebug and I see the sSearch_0, sSearch_1, sSearch_2, etc...

I am using server-side VB.NET AND MSSQL. Searching on all the columns is taking too long. I would like to add a Select option to the left of the search:

All
First Name
Last Name
Email
Account


This could assing to the Search_(int) field. Can this be done and can you please share an example.

Thank you

allan

One option might be to look at optimising your SQL if the server-side filtering is taking to long. You can pass extra parameters to the server as shown here: http://datatables.net/release-datatables/examples/server_side/custom_vars.html - which could be used to indicate what columns should be sorted on.

Allan