Null value in date field: "null" appears, I want to show empty or custom text

[Dave]

Hello,

I have a TreeList with a nullable date field to be displayed.  The following line adds the field to my Treelist:

    columns.Add().Field(e => e.LastUsed).Format("{0:MMMM d, yyyy}"); 

If the date field has a value, then the date is displayed.  If it is null, the word "null" is displayed.  I would like to be able to display either a custom text string like "N/A" or a blank, instead of the word "null".

I also don't want to convert the Treelist to all javascript. 

Thank you very much for your assistance.

Dave

[Alexander Popov]

Hi Dave,

This can be done using a column template that checks the value and renders different text accordingly. For example: 

"#if(myField === null){# N/A #}else{# #=myField#  #}#"

Regards,
Alexander Popov
Telerik

 

 

[Dave]

Hi Alexander,

Sorry for the delay in replying back to you.  Thanks for providing a solution.  I appreciate it.  Have a nice day...

Dave

[Chris]

null to "" (not "null") should handle by component directly, right ? null to "" - handle by programmer is not reasonable in physical implementation.

 

Best regards

 

Chris

 

 

[Stefan]

Hello, Chris,

Thank you for the feedback.

Could you please advise how would you expect the null values to be shown by the Kendo UI TreeList by default? This will help us discuss the approach and advise if it is applicable in the widget.

Thank you in advance.

Regards,
Stefan
Progress Telerik

[Chris]

Not only TreeList, I think all components(ex. TextBox,etc.) should default show empty("") while the value is null. 

 

Best regards

 

Chris

 

 

[Stefan]

Hello, Chris,

For now, displaying null is the default behavior and changing it will cause a breaking change in the widgets.

If the Kendo UI community thinks that displaying empty string by default is a better behavior please submit a feature request in our feedback portal and based on its popularity we may implement it in a future release:

http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback


Regards,
Stefan
Progress Telerik

[darryl]

6 years later... Its for reasons like this that i stopped subscribing to kendo. very poor decision on a library meant to DISPLAY data to end-user. Then no fix for it as if ANYONE wants "null" to display to end users.  Forcing implementors to add stupid if null to the frontend logic or converting null to empty string in backend is beyond stupid.

[Nikolay]

Hi Darryl,

Thank you for the feedback.

The solution to this is to use a template for the column that contains null values. Please refer to the first reply in this thread:

• https://www.telerik.com/forums/null-value-in-date-field-null-appears-i-want-to-show-empty-or-custom-text#3842857

Regards,

Nikolay