Search

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'},

The Columns and Field classes both

obtain data from SQL columns, as shown above, it

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

object we might use: columns: [ { data: "users.first_name" }, { data: "permission",

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

You can use column().visible() to show or hide columns based on your condition. So I search for columns that start with A. Are you wanting to search the column header names? You can use columns().header(). Kevin

Your columns fields is an array with a single object, all containing the key data - it should be "columns": [ {"data": "start"}, {"data": "end"}, {"data": "recipients"}, {"data": "message"}, {"data": "collateral"}, {"data": "rep"}, {"data": "message"}, ] Colin

expect to find the columns definition, draw, search, start

try to add extra columns to the table, all

Hi @Alessandrova , You can force panes for specific columns to show using the columns.searchPanes.show option. This example should help. Thanks, Sandy

rm_filter'), }, rows: { autoHide: false, }, columns: [ { field: "reporting-to-name", title: " Reporting

With the comma, in console it tells me unexpected token ',' and without the comma it tells me unexpected token ':' @ "columns": [

You can have as many columns as you want - just define them in columns or in the DOM. Are you seeing errors when you try this? Colin

off sorting on certain columns. You can use columnDefs

setup is the following: columns: [ . . . { data: null, searchable: false,