Jquery Datatable null column

Question

Hi i have created the jquery datatable using below code..

The column email id and activated date is may be nullable. When i render the table it is showing 'Request unknown parameter 'email' from data source for row 0'

 var tblAllKeys = $('#tblAllKeys').dataTable({
                    "bDestroy" : true,
                    "bProcessing" : true,
                    "bServerSide" : true,
                    "bLenthChange" : false,
                    "iDisplayLength" : 10,
                    "sAjaxSource" : "loadAllKeys",
                    "oLanguage" : {
                        "sSearch" : "Search By Activation Key:"
                    },
                    "aoColumns" : [
                     {"sTitle" : "No.","mData" : null,"aTargets": [ 0 ],
                        "fnRender" : function(obj) {
                            var columnIndex = obj.oSettings._iDisplayStart + obj.iDataRow+1
                            return columnIndex;
                        }
                    },
                    {"sTitle" : "Activation Key","mData" : "key", "bSearchable" : true},
                    {"sTitle" : "Email ID","mData" :  "email" , "bSearchable" : false},
                    {"sTitle" : "App Edition","mData" : "edition", "bSearchable" : false},
                    {"sTitle" : "Batch Code","mData" : "batch", "bSearchable" : false},
                    {"sTitle" : "Activated Date","mData" : "aDate" , "bSearchable" : false},
                    {"sTitle" : "Generated Date","mData" : "gDate", "bSearchable" : false},
                    {"sTitle" : "Status","mData" : "status", "bSearchable" : false},
                    ],
                       "fnServerData" : function(sSource, aoData, fnCallback) {
                        $.ajax({
                         "dataType" : 'json',
                         "type" : "GET",
                         "url" : sSource,
                         "data" : aoData,
                         "success" : fnCallback
                        });
                       },
                       "sPaginationType" : "full_numbers",
                });

nullable or the column itself will not be present?

Guruprasad J Rao
– Guruprasad J Rao

2016-11-08 09:35:38 +00:00
Commented Nov 8, 2016 at 9:35 — Guruprasad J Rao
– Guruprasad J Rao, Commented Nov 8, 2016 at 9:35
no column is present. only value is null

boycod3
– boycod3

2016-11-08 09:36:35 +00:00
Commented Nov 8, 2016 at 9:36 — boycod3
– boycod3, Commented Nov 8, 2016 at 9:36

Guruprasad J Rao · Accepted Answer · 2016-11-08 09:40:48Z

2

You can make use of columns.defaultContent option available as per their docs on this error, to display default value or empty string when column's doesn't have any value.

"aoColumns": [{
  "sTitle": "No.",
  "mData": null,
  "aTargets": [0],
  "fnRender": function(obj) {
    var columnIndex = obj.oSettings._iDisplayStart + obj.iDataRow + 1
    return columnIndex;
  }
}, {
  "sTitle": "Activation Key",
  "mData": "key",
  "bSearchable": true
}, {
  "sTitle": "Email ID",
  "defaultContent":"",//or specify any other value
  "mData": "email",
  "bSearchable": false
}, {
  "sTitle": "App Edition",
  "mData": "edition",
  "bSearchable": false
}, {
  "sTitle": "Batch Code",
  "mData": "batch",
  "bSearchable": false
}, {
  "sTitle": "Activated Date",
  "mData": "aDate",
  "bSearchable": false
}, {
  "sTitle": "Generated Date",
  "mData": "gDate",
  "bSearchable": false
}, {
  "sTitle": "Status",
  "mData": "status",
  "bSearchable": false
}, ],

Its good to assign defaultContent option to all the columns if you are sure that any of the column might come empty.

answered Nov 8, 2016 at 9:40

Guruprasad J Rao

29.7k16 gold badges113 silver badges212 bronze badges

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

6 Comments

Guruprasad J Rao Over a year ago

Could you please try replicating it here with sample data?

boycod3 Over a year ago

Do you mean the response from server?

boycod3 Over a year ago

{"iTotalRecords":0,"iTotalDisplayRecords":0,"sEcho":2,"aaData":[{"key":"JPBFTU3Q1MOY","edition":"Professional Edition","batch":"PROMOTIONAL TRIAL KEYS 1","gDate":"05/11/2016","status":"Unsubscribed"}]}

Guruprasad J Rao Over a year ago

Your aaData does not contain email id column?

boycod3 Over a year ago

I think i know what the issue is. i'm not sending email from server.

|

Collectives™ on Stack Overflow

Jquery Datatable null column

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related