Replace null default values with a default string

[Stephen Abel]

Hi,

In a grid control I receive a nullable date field. For the null values, rather than just displaying a blank cell, is there a way of setting a default value so it could display something like 'No date supplied' instead?

Thanks,

Steve

[Seeni Sakthi Kumar Seeni Raj]

Hi Stephen, 

 

You can use the queryCellInfo event of the Grid to modify any cells in the Grid. Therefore, for a null date values, you can use the queryCellInfo event and format the cells.  

Based on the type of the column and values present in the current cell, text of the particular has been replaced. Refer to the following code example and API Reference. 

 

<div id="Grid"></div> 

<script type="text/javascript"> 

    $(function () { 

        var data = [ 

            { OrderID: 10248, OrderDate: new Date() }, 

            { OrderID: 10249, OrderDate: null }, 

            { OrderID: 10250, OrderDate: "" } 

        ] 

        $("#Grid").ejGrid({ 

            dataSource: data, 

            allowPaging: true, 

            queryCellInfo: function (args) { 

                if (args.column.type == "date" || args.column.type == "datetime") { 

                    var val = ej.getObject(args.column.field, args.data); 

                    if (ej.isNullOrUndefined(val) || val == "") 

                        $(args.cell).text("No Date Supplied"); 

                } 

            }, 

            columns: [ 

                { field: "OrderID" }, 

                { field: "OrderDate", format: "{0:MM/dd/yyyy}" } 

            ], 

        }); 

    }); 

</script> 

 

  

https://help.syncfusion.com/api/js/ejgrid#members:columns-type 

https://help.syncfusion.com/api/js/ejgrid#events:querycellinfo 

 

We have prepared a sample that can be referred from the following jsPlayground. 

 

https://jsplayground.syncfusion.com/2zet3a4e 

 

Regards, 

Seeni Sakthi Kumar S. 

[Stephen Abel]

Thank you - that is exactly what I was looking for.

[Mohammed Farook J]

Hi Stephen, 

  

Thanks for updated. 

  

Regards, 

J.Mohammed Farook