Grid Missing Value

[Tim]

I have a grid that has first and last name columns. There are people whose last name is 'Null' (a STRING value, NOT the database/JSON value null). The last name cell is blank for these people. Is this a bug or a feature? Is there any way to configure the grid to display the actual value 'Null' instead of blank?

Here's part of the JSON:

        {
            "FirstName": "John",
            "LastName": "Null",
            "GradeValue": "2"
        },
        {
            "FirstName": "Jane",
            "LastName": "Null",
            "GradeValue": "2"
        },

[Viktor Tachev]

Hi Tim,

By default if the value of a field is Null it will be interpreted as empty and not shown in the Grid component. However, if you would like to display a Null in a cell I suggest utilizing the template configuration for a column. The configuration for the LastName column would look similar to this:

columns.Bound(p => p.LastName).ClientTemplate("#=LastName==='Null'? 'Null' : LastName #");

 

Let me know how the suggested configuration works for you.

 

Regards,
Viktor Tachev
Progress Telerik

[Tim]

Hi Viktor,

That changes things, but I don't think the 'if' is being executed because it prints it without a capital 'N':

I have a content security policy, so I converted it to a function:

columns.Bound(x => x.LastName).ClientTemplateHandler("LastNameTemplateHandler");

function LastNameTemplateHandler(data) {
    if (data.LastName === 'Null') {
        return 'Null';
    }
    else {
        return data.LastName;
    }
}

Does it work for you?

Thanks,

Tim

[Viktor Tachev]

Indeed using the if condition like this would display null with lower case 'n'. The reason being that, since in most cases null is a special value, internally the string "Null" will be converted to null. Thus, the first part of the if will never be true and the else option will be returned. 

In order to show Null with a capital "N" I suggest changing the template handler like this:

function LastNameTemplateHandler(data) {
    if (data.LastName === null) {
        return 'Null';
    }
    else {
        return data.LastName;
    }
}

[Tim]

That works. Thank you for your help.