Checking null values in Datatable Column while rendering using Jquery

Question

I am using datatable to display my data. In one of my columns i am using a render to check the null if it is not null then display the data using split method. The code is working but it gives a browser warning every time it finds a null value.

here is my code

{
  "mData": "address",
  "render": function(data, type, row) {
    if (data == null) { //do nothing}
      else {
        return data.split("\n").join("<br/>");
      }
    }
  }
}

here is the warning message I get

DataTables warning: table id=tblrss - Requested unknown parameter 'address' for row 2, column 5. For more information about this error, please see http://datatables.net/tn/4

Did you read the information provided in datatables.net/tn/4? — fdomn-m
– fdomn-m, Commented Apr 19, 2021 at 14:02
Your code, as provided, will give a syntax error and not run. — fdomn-m
– fdomn-m, Commented Apr 19, 2021 at 14:02
Each cell in DataTables requests data, and when DataTables tries to obtain data for a cell and is unable to do so, it will trigger a warning, telling you that data is not available where it was expected to be - so give it some data: if (data == null) { return "" }? — fdomn-m
– fdomn-m, Commented Apr 19, 2021 at 14:03
@freedomn-m thanks yeah i forgot to return anything when it is null, that solve the problem — user388969
– user388969, Commented Apr 19, 2021 at 14:08

codeandcloud · Accepted Answer · 2021-04-19 14:15:07Z

2

Try this

{
  "mData": "address",
  "render": function(data, type, row) {
    return data ? data.split("\n").join("<br/>") : "";
  }
}

answered Apr 19, 2021 at 14:15

codeandcloud

55.5k47 gold badges169 silver badges259 bronze badges

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

Comments

user388969 · Accepted Answer · 2021-04-20 15:54:02Z

0

    {
 "mData": "address",
 "render": function(data, type, row) {
  if (data == null) { return "" }
  else {
    return data.split("\n").join("<br/>");
  }
}

//adding something to return when null solved the problem thanks to @freedomn-m

answered Apr 20, 2021 at 15:54

user388969

3411 gold badge9 silver badges33 bronze badges

Collectives™ on Stack Overflow

Checking null values in Datatable Column while rendering using Jquery

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related