Search

I was able to figure it out using $sGroup = "GROUP BY accounts.accountname"; Added $sGroup after $sWhere Thank you

Agreed - sDom is how to control what controls DataTables adds to the document. Allan

you can use fnServerParams see the reference documentation on http://datatables.net/ref [quote] It is often useful to send extra data to the server when making an Ajax request - for example custom filtering information, and this callback function makes it trivial to send extra information to the server. The passed in parameter is the data set that has been constructed by DataTables, and you can add to this or modify it as you require. [/quote] you can push the value of your checkbox onto the aoData array [code] $(document).ready( function() { $('#example').dataTable( { "bProcessing": true, "bServerSide": true, "sAjaxSource": "scripts/server_processing.php", "fnServerParams": function ( aoData ) { aoData.push( { "name": "status", "value": $('#my_secret_checkbox').val() } ); } } ); } ); [/code]

sorry for double posting, working link here http://s24.postimg.org/uyat0hw5x/image.jpg

Its possible using Editor 1.2.3 and the attr option for the fields: http://editor.datatables.net/fields/#text . [code] editor.add( { "label": "Name:", "name": "name", "attr": { "placeholder": "Your name" } } ); [/code] The attr option is attractive because it allows any HTML attribute to be controlled on the input element. Regards, Allan

How about using the placeholder attribute: http://live.datatables.net/uhaxez/edit#javascript,html Allan

"aren't submitting the values DataTables needed for server-side processing" - no, they were getting passed in correctly. (i should have shown the searchTerms) anyway, got it finally. it was simply this: success: fnCallback, in the ajax call. fnServerData requires that unlike sAjaxSource (apparently!) :) many thanks allan...

Anything in the THEAD is excluded, anything in TBODY (including TH cells) is included. To exclude certain cells you'd need to use custom filtering. Allan

Well, finally i did it using regular expression thanks to another post i found on this forum. Here's my solution to look for something different than "No" for the column 7. [code]table.fnFilter('^((?!No).)*$', 7, true);[/code]

Many thx for the answer first of all. I just see this example but i don't understand how to merge the two examples.