How to handle database null values in jquery datatable

Question

I have a jquery datatable with the data coming from database,fetched from java servlet.Few columns have null values.Because of this i am getting warning like

DataTables warning: table id=lplist - Requested unknown parameter 'FeeCompany' for row 9. For more information about this error, please see http://datatables.net/tn/4

I want those null values to be replaced by empty string.Can someone please guide how to achieve this.

My code snippet is as below

    <script
    src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js"></script>
<script
    src="http://cdn.datatables.net/1.10.4/js/jquery.dataTables.min.js"></script>

<script
    src="http://cdn.datatables.net/scroller/1.2.2/js/dataTables.scroller.min.js"></script>
<link
    href="http://cdn.datatables.net/scroller/1.2.2/css/dataTables.scroller.css"
    rel="stylesheet" type="text/css" />

<link href="http://cdn.datatables.net/1.10.4/css/jquery.dataTables.css"
    rel="stylesheet" type="text/css" />
<title>Insert title here</title>
<script type="text/javascript">
            $(document).ready(function () {
                $("#lplist").dataTable({
                    "serverSide": true,
                    "sAjaxSource": "/JQueryDataTablesAll/CompanyGsonObjects",

                    dom: "rtiS",
                    scrollY: 450,
                    scrollX:true,
                    "processing": true,                     
                    "aoColumns": [
                                  { "mData": "InsuredName" },
                                  { "mData": "CustAddress_City" },
                                  { "mData": "CustAddress_State" },
                                  { "mData": "CustAddress_Zip" },
                                  { "mData": "CustSurvey_Location" },
                                  { "mData": "PolicyNo" },
                                  { "mData": "ProfitCenter" },
                                  { "mData": "FeeCompany" }, 

                              ]



                });
            });
        </script>
</head>
<body id="dt_example">
    <div id="container">
        <div id="links">
            Server-side processing with object source <br />
        </div>
        <div id="demo_jui">
            <table id="lplist" class="display">
                <thead>
                    <tr>
                        <th>Insured Name</th>
                        <th>City</th>
                        <th>State</th>
                        <th>Zip</th>
                        <th>Survey Location</th>
                        <th>PolicyNo</th>
                        <th>Profit Center</th>
                        <th>Fee Company</th>                        

                    </tr>
                </thead>
                <tbody>
                </tbody>
            </table>
        </div>

    </div>

Pathros · Accepted Answer · 2020-07-18 19:53:33Z

14

Add defaultContent in the options while initializing the data table. For more details

columns.defaultContent

Example from the official documentation:

$('#example').dataTable( {
  "columns": [
    null,
    null,
    null,
    {
      "data": "first_name", // can be null or undefined
      "defaultContent": "<i>Not set</i>"
    }
  ]
} );

edited Jul 18, 2020 at 19:53

Pathros

10.8k21 gold badges103 silver badges166 bronze badges

answered Dec 16, 2014 at 10:33

shailb

1641 silver badge4 bronze badges

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

Comments

markpsmith · Accepted Answer · 2014-12-17 12:02:37Z

5

You can use mRender to specify the display in the event of a null value:

{ 
    "mData": "FeeCompany" 
    'mRender': function (data, type, full) {
        if (full[7] !== null) {
             return full[7]; 
         }else{
             return '';
         }
},

answered Dec 17, 2014 at 12:02

markpsmith

4,9182 gold badges38 silver badges65 bronze badges

Comments

Not A Robot · Accepted Answer · 2021-04-01 13:06:35Z

0

{

  "data": function(data, type, dataToSet) {

    return data.CourseEducator1 ? ? " " + "<br/>" + data.CourseEducator2 ? ? ";

  }

}

edited Apr 1, 2021 at 13:06

Not A Robot

2,7002 gold badges20 silver badges37 bronze badges

answered Apr 1, 2021 at 9:15

Hilal Borazan

1

1 Comment

Hilal Borazan Over a year ago

when we want to return more than one data in a column, a block of code that shows blank instead of null if there is empty space

Collectives™ on Stack Overflow

How to handle database null values in jquery datatable

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related