Date Formatting Template missing for Grafana Notification Lists

Products

• VMware Telco Cloud Service Assurance

Issue/Introduction

When trying to format one of the Date fields, the format does not display as expected.

When selecting the Field Override, Standard Options - Unit, selecting DateTime US, column such as "First Notified", "Last Notified" and "Last Cleared" displays the value "NaN" (Not a Number) instead of the regular time format (YYYY-MM-DD hh:mm:ss). 

There is no format option for the time display to YYYY-MM-DD hh:mm:ss display.

 

Environment

2.3.1.

Cause

When data is inserted into the database, it is inserted as the field type TEXT instead of field type NUMBER.

Resolution

To workaround the issue, when creating the query, add the "Transform Data" parameter for the "Date Fields" to make them "Number".  

Once that is done, add field override for "Standard Unit of DateTime Local".
The date will display correctly.