Search

A list of the columns to be written to

options SearchPaneOptions->label( string|string[] ) - The column(s) that contain the label

if you get multiple columns with ->label() and wish

such nested JSON data. columns: [ { data: "users.first_name" }, { data: "permission",

url: '../php/join.php', type: 'POST' }, columns: [ {data: 'users.first_name'}, {data: 'users.last_name'},

table required the join columns to be defined in

selection into two distinct columns for the Responsive with

Inline editing for specific columns Update - examples: Use datetime

used Fix PHP: Support columns with a dash (-) in

Aliasing fields to read columns from the parent table

as that defines where columns are and aren't shown.

SOLVED: there was one sneaky row that had no data in it in the new column(s) that appears to be causing the error. Thanks for your help @LukasL , @kthorngren !

search boxes for certain columns // the title of the

getting between the two columns when I remove the

Ok, thanks for the answer. I'll write my own middleware that adds more columns to saved settings before they're loaded if column count in the table is more than what it was when settings were saved.

renderer for those hidden columns. How would I do

When you say "flip columns", do you means columns 1,2,3,4 would be 4,3,2,1 on the export? Colin

Build the array in a more procedural way: $columns = array(); $columns[] = array( 'db' => 'MTLOC', 'dt' => 'location_code' ); if ($taskFormType === 'myType') { $columns[] = array( 'db' => 'MTCODE', 'dt' => 'machine_code' ); } // etc - add more columns Allan

Add a class to those columns you don't want to search using columns.className. Use that classname is the column-selector with the jQuery :not() selector to to skip those columns. See the updated example: http://live.datatables.net/hukileju/9/edit Kevin

the 2nd and 3rd columns. You could use columns.render to extract the particular