Columndefs not working Datatables

Question

I am trying to work with columndefs to add custom colors to a column. But i started with a simple scenario just to get columndefs to work. But i am unable to do so.

This is my CoffeeScript file.

jQuery ->
      $('#clients').dataTable
        columns: [
          targets: [0]
          visible: false
        ]
        sAjaxSource: $('#clients').data('source')

I have a ROR application. i am using jquery-datatables-rails gem version: 2.2.3 https://github.com/rweng/jquery-datatables-rails which installs the latest version of datatables - 1.10.

I am not sure why i am unable to set visibility for column zero to be false.

have you tried `"columnDefs":[{visible: false, "targets":0}]` or `"columns": [{visible: false}]` as specified in the [Reference Docs](http://datatables.net/reference/option/columns.visible) — engineersmnky, Oct 23 '14 at 21:01
I just noticed a syntax error in my comment `visible` should be `"visible"` — engineersmnky, Oct 24 '14 at 13:53
I've already tried columns and columndefs. Did not help. The quotes do not help as well since this is a Coffeescript file. — user2611745, Oct 24 '14 at 14:49
the problem is your syntax you are correct the quotes are wrong for coffeescript but you need to fix your syntax for this to work. — engineersmnky, Oct 24 '14 at 15:24
`columns:[targets:[0],visible:false]` is incorrect try `columns:[{visible:false}]` and see if that works — engineersmnky, Oct 24 '14 at 16:07
really interested to know if you got columns and columnDefs working together, I'm seeing a similar problem — dougajmcdonald, Feb 09 '16 at 20:58

Robbie · Answer 1 · 2015-06-08T14:00:08.767

6

The format you originally used is for 'columnDefs', with 'column' you have to specify for all columns see examples.

However I've always had issues with both formats not working so a workaround is to dynamically hide the column after initializing it using:

$('#clients').DataTable().column( 0 ).visible( false )

edited Jun 08 '15 at 14:00

answered Jun 08 '15 at 13:53

Robbie

61
1
5

This is the ONLY option that worked for me. Thankyou – davaus May 16 '19 at 04:18

Andrew · Answer 2 · 2018-09-12T17:57:33.063

As Robbie said in his answer, the options given for columns in your example are actually the options meant for columnDefs. However, it should still work since "visible" is a valid property for both columns and columnDefs. Since column options are index based, the "targets" property is just ignored.

I had issues with column visibility as well until I realized that the stateSave option overrides column visible. Though you don't set stateSave in your example, the only reason I can think of for column visible to not work is having stateSave set to true.

You can override the stateSave logic by using the stateSaveParams callback detailed here.

score 1 · Answer 3 · answered Dec 30 '14 at 01:02

1

Maybe you have a missing comma after targets: [0]

columns: [
          targets: [0],
          visible: false
        ]

answered Dec 30 '14 at 01:02

benjamingranados

438
5
15

Columndefs not working Datatables

3 Answers3