Search

column which has its columns.name property set to the

column, as defined by columns.name. columns[i][data] string Column's data

indexes or column names (columns.name) - these keys are used

When working with DataTables' API, it is very common to want to be able to address individual columns so you can work with them (you wish to sum the numeric content of a column for example). DataTables has two basic methods of addressing columns: As a column index (automatically assigned when the table is initialised) With a name - assigned using this option! This can make working with columns in the API very easy - for example to access the data from the column named location you would use table.column( 'location:name' ).data() - append the string :name to indicate to DataTables that it should perform a column name selector operation. For more information about column selectors, please see the column() documentation.

Column name selector, from columns.name (e.g. salary:name) {string}:title - Column

column name defined by columns.name is used to identify

through use of the columns.name parameter. The name is

a name defined using columns.name (since 2.0). A string

system makes use of columns.name to uniquely identify a

in what order sName columns.name Set a descriptive name

I'm trying to get my column names: table.columns().names() My DataTable does have names: columns: [ { name: "abc", ...}, { name: "def", ...} ] However I get the following error: .columns(...).names is not a function Am I missing something obvious?

Yeah - ideally don't use information from the settings object. It is considered to be private. it can, may and does change between versions at times, so use with caution. If you do use it, wrap any use into a plug-in API method so if it does break in future, you can update it in just one place. Allan

You could use this little plug-in: $.fn.dataTable.Api.register( 'columns().names()', function () { return this.iterator( 'column', function ( settings, column ) { return settings.aoColumns[column].sName; }, 1 ); } ); And call like: table.columns().names(). I'm assuming you are referring to a name as in columns.name? Allan

Hi @colin Just have a search to columns().names() here and click on column().name() or in case columns().name() to get the link B)

I haven't tested it, but this should do it: $.fn.dataTable.Api.registerPlural( 'columns().names()', 'column().name()', function ( setter ) { return this.iterator( 'column', function ( settings, column ) { var col = settings.aoColumns[column]; if ( setter !== undefined ) { col.sName = setter; return this; } else { return col.sName; } }, 1 ); } );

Very clever - nice one :smile:. Thanks for sharing your solution with us. I'm going to add a columns().names() method in future, the current absence of which is what I was referring to above. Allan

Hello @allan I see the documentation of column().name() or columns().names() and make some tests, but they are undefined. This function has depreciated or removed?

var count = 1; var columnsNames = []; $('thead th').each(function() { columnsNames.push({'data': $(this).data('name')}); }); var table = $('.myDataTable').DataTable({

I have defined the columns.names and I can use

datatables add the proper columns/names to the table? Can