JQGRID show blank instead of Null

jqgrid, jquery

Solution

It's probably best that you handle this server-side, but if you want to do it in jqGrid, you could use a custom formatter that converts null to the empty string. (I'm not sure if you are actually getting back the value `null` or the String `"NULL"`, so I handled both cases):

var nullFormatter = function(cellvalue, options, rowObject) {
    if(cellvalue === undefined || isNull(cellvalue) || cellvalue === 'NULL') {
        cellvalue = '';
    }

    return cellvalue;
}

$("#myGridContainer").jqGrid({
    ....
    colModel: [{
        label: 'Name',
        name:'name',
        index:'name',
        formatter:nullFormatter
    }, {
        label: 'Next Column',
        name:'nextCol',
        index:'nextCol',
        formatter: nullFormatter
    }, ...],
    ....
}

Problem

Am using `JQGrid` and am getting Null displayed in the grid as it comes from DB. I can change the query to return Blank value. But am try to handle using JQGrid. How do i `replace null by blank values` in Grid. I don want to show NULL to users instead show blank. How do i achieve this in JQGrid ? Thanks

Original source