Angular Datatable Set Searchable False

Question

I'm trying to set search disable on specific column. Im using this angular datatable server side.

https://l-lin.github.io/angular-datatables

usually on jquery i can just:

 columns:[{data:"foo", name:"foo", searchable:false}]

I've tried use:

   $scope.dtOptions = DTOptionsBuilder.newOptions()
            .withOption('ajax', {
                url: apiRoot + 'merchant-list'
            })
            .withDataProp('data')
            .withOption('serverSide', true)
            .withOption('order', [0, 'asc'])

  $scope.dtColumns = [
            DTColumnBuilder.newColumn('name', 'Name'),
            DTColumnBuilder.newColumn('type', 'Type'),
            DTColumnBuilder.newColumn('username', 'Username'),
 ]

 $scope.dtColumnDefs = [
            DTColumnDefBuilder.newColumnDef(0),
            DTColumnDefBuilder.newColumnDef(1).withOption('searchable', false),
            DTColumnDefBuilder.newColumnDef(2).withOption('searchable', false)
        ]

seems to work but, the position of columnDef is not correct. when i put newColumnDef(1) searchable to false, the column not to be search should be the second one, but apparently it disable the first column.

Is there way to make it disabled search for specific column and order it?

Thanks

Edit: I've tried 'orderable',false and notvisible is working on columnDef 0. Looks like only searchable is fail.

davidkonrad · Accepted Answer · 2015-09-24 10:12:58Z

7

Both DTColumnBuilder and DTColumnDefBuilder items must be declared inside an array :

$scope.dtColumns = [
   DTColumnBuilder.newColumn('name', 'Name').withOption('searchable', false)
   ...
]

And then it works -> http://plnkr.co/edit/OOikiBKdLE8R1UEXLyMH?p=preview

or

$scope.dtColumnDefs = [
   DTColumnDefBuilder.newColumnDef('name', 'Name').withOption('searchable', false)
];

edited Sep 24, 2015 at 10:12

answered Sep 23, 2015 at 11:49

davidkonrad

85.7k17 gold badges211 silver badges273 bronze badges

Sign up to request clarification or add additional context in comments.

8 Comments

ssuhat Over a year ago

Hi, thanks for answering. notSortable is only for disable sorting. I want disable search for specific column like my above explanation.

davidkonrad Over a year ago

@sstarlight, have renewed the answer. I really dont know why I was thinking about sortable and not searchable.

ssuhat Over a year ago

Hi. THanks for reply. looks like i make it worked using columndef but with seperate dtcolumn. sometimes it's not working it still try to find the data. :| looks like i'm going to replace it and use jquery for datatable instead. looks alot easier to handle than angular one. Thanks bro

davidkonrad Over a year ago

Hey @sstarlight - I raised it as an issue to the author on github, he responded 15 min later with : "Your $scope.dtColumnDefs must be an array. See the corrected plnkr. (wich is plnkr.co/edit/YIEO1kww7njo5G5I03eV?p=preview) I dont think we come closer to that :) it is ColumnDefs being used in the example.

ssuhat Over a year ago

Hi, thanks for helping me to post it author github. I've updated my answer above. and i stil try to solve it. Looks like the problem is on using server side.

|

slfan · Accepted Answer · 2016-08-05 11:00:24Z

7

$scope.dtOptions = {searching:false}

will work fine with latest angular versions.

edited Aug 5, 2016 at 11:00

slfan

9,129115 gold badges69 silver badges81 bronze badges

answered Aug 5, 2016 at 10:37

learn2code

1532 silver badges9 bronze badges

2 Comments

Shivam Mishra Over a year ago

it works fine but it can replace other property. so better way is to after assign some 'dtOptions' just use $scope.dtOptions.searching = false

learn2code Over a year ago

Yeah ..! Of course . But if you want set more than one properties. Better approach is to use object notation.

Collectives™ on Stack Overflow

Angular Datatable Set Searchable False

2 Answers 2

8 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related