How can I disable xeditable on a two datatable columns using columnef function inside the datatable?

Question

Hello here is my code for inline grid editing .

I would like to disable the xeditable inline grid editing on couple of columns

Here is my code

   "columnDefs": [
         {'targets': '_all',
            'createdCell':  function (td, cellData, rowData, row, col) {
               $(td).attr('data-pk', rowData['id']);
               const key = Object.keys(rowData)[Object.values(rowData).indexOf(cellData)];
               $(td).attr('data-name', key );
           }},
    ],
    "fnDrawCallback":function(){
          $('#data_table_list td').editable({
           params: function(params) {
                var pk = $(this).data('pk');
                var name = $(this).data('name');
                var data = {};
                data['field'] = name;
                data['value'] = params.value;
                data['id'] = pk;
                data['slug']=slug;
                return data;
           },
           url: "{% url 'request_access' %}",
             success : function(data) {
             if (data.status == true) {
                    toastr.success(data.msg);
                } else {
                    toastr.error(data.msg);
                }
            },
            error: function () {
                toastr.error('Something went wrong');
            }
         });
    },

I have got one method .... IF I do like that I can avoid 4th & 5 columns in datatable. But I need to pass all the column numbers.

"columnDefs": [
             {class:'my_class',targets': [1,2,3,6,7,8,9,10....],
                'createdCell':  function (td, cellData, rowData, row, col) {
                   $(td).attr('data-pk', rowData['id']);
                   const key = Object.keys(rowData)[Object.values(rowData).indexOf(cellData)];
                   $(td).attr('data-name', key );
               }},
        ],
        "fnDrawCallback":function(){
          $('#data_table_list .my_class').editable({
           params: function(params) {
                var pk = $(this).data('pk');
                var name = $(this).data('name');
                var data = {};
                data['field'] = name;
                data['value'] = params.value;
                data['id'] = pk;
                data['slug']=slug;
                return data;
           },
           url: "{% url 'request_access' %}",
             success : function(data) {
             if (data.status == true) {
                    toastr.success(data.msg);
                } else {
                    toastr.error(data.msg);
                }
            },
            error: function () {
                toastr.error('Something went wrong');
            }
         });
    },

Answer 1

Just need to give a diffrent class name for excluded columns.....

"columnDefs": [

             {targets:[4,5],className:"truncate"},

             {className:'my_class','targets': '_all',,
                'createdCell':  function (td, cellData, rowData, row, col) {
                   $(td).attr('data-pk', rowData['id']);
                   const key = Object.keys(rowData)[Object.values(rowData).indexOf(cellData)];
                   $(td).attr('data-name', key );
               }},
        ],
        "fnDrawCallback":function(){
          $('#data_table_list .my_class').editable({
           params: function(params) {
                var pk = $(this).data('pk');
                var name = $(this).data('name');
                var data = {};
                data['field'] = name;
                data['value'] = params.value;
                data['id'] = pk;
                data['slug']=slug;
                return data;
           },
           url: "{% url 'request_access' %}",
             success : function(data) {
             if (data.status == true) {
                    toastr.success(data.msg);
                } else {
                    toastr.error(data.msg);
                }
            },
            error: function () {
                toastr.error('Something went wrong');
            }
         });
    },