How to check null values using kendo template

Question

Hi I've a kendo grid like below and I wanted to check null value for column and based on condition I want to display some default number to the column

Here is my sample code.

 $("#eCount").kendoGrid({
        dataSource: {
            data: myModel,
            pageSize: 5
},      
 columns: [
            {
                field: "Count",
                title: "Count",
                template: '# if (Count == "null" ) {#1#} else {#Count#}#'
            }]
});

But I'm not getting how to get it done. Any solution?

I've got the soluion '#if(Count===null) {# 1 #}else{# #=Count# # }# ' it is working for me — jestges, Aug 05 '13 at 17:52

score 49 · Answer 1 · answered Feb 12 '14 at 21:50

49

You can use Javascripts inline if format

#= street2 != null ? street2 : '' #

answered Feb 12 '14 at 21:50

A.J.

904
9
20

That works! In a multi-valued address (street1,county, state,country) - how to skip commas beside null values – Vamshi Vangapally Jan 14 '19 at 15:32
you can do an .indexOf(',') to see if the string has a comma in it. Is that what you are asking? – A.J. Apr 11 '19 at 18:53

score 20 · Answer 2 · answered Apr 08 '15 at 15:14

I found this to be the most usefull:

#= typeof street2 == "undefined" || street2 == null ? "" : street2 #

The typeof check can be useful when adding rows programatically to the grid's datasource and not specifying the value for the street2 field:

grid.dataSource.add({}); //this line will generate an error when you're not using 'typeof' check

Also related to your question, for more complex scenarios, I've also found useful to do other checks inside the template using data.xxx, like this:

# if (data.street2 && data.street2.length) { #
    <span>#: street2 # </span>
# } else { #
    <span>N/A</span>
# } #

If you have a Kendo drop down list column as a custom MVC editor in a Kendo grid and the drop down list is empty, you have to use the 'typeof' check cited. Initially, I was only checking if the value is null, but it's actually undefined. One symptom of this is that you'll get an undefined reference error from jquery on your custom template. — SamG, Dec 31 '16 at 18:57

jwize · Answer 3 · 2015-01-23T05:55:22.093

var dataSource = new kendo.data.DataSource({
    transport: {
    ...
    },
    schema: {
        model: {

            myCount: function () {
                return this.get("Count") == null ? 1 : this.get("Count");
            }
        }
    }

<script id="template">
        #=myCount()#
</script>

Or you can do this if you are not using a datasource.

<script id="template">
    # var count = data.Count || 1; # // Javascript  #   #
    <span>#=count#</span>            // Binding  #=   #
</script>

How to check null values using kendo template

3 Answers3