Software Version converted to Date format automatically
we have a Pie Chart dashboard with data from SCCM. In this dashboard we list all installed Mozilla Firefox versions which are installed on our clients (+ amount of installations). We also enabled "Display selected item details" so we can filter through all available versions - which leads to our problem. The format of the Firefox versions is xx.xx.x. So when we want to display details from the selected versions, the Kendo UI interprets these as a date (As seen in the screenshot):
In the Pie Chart everything is fine though. Even when we execute the dashboard query in our SQL management studio the format is as expected. We also tried to cast the Productversion0 into a varchar in the select statement, which didn't change anything.
So, is there any way to tell the Kendo UI to interpret the product Version as a string and not as a Date?
@Simon_Zeinhofer Is this a custom page?
Or just using the out of the box SQL widgets?
If the answer is the latter, please log a support ticket as this will be an issue in the source code which we will be able to assist you with!
@Shane_White It is an out of the box SQL widget.
Thank you for the fast response, I will open a support ticket for this :)