Oracle DB returns this TimeStamp: "2018-11-07T00: 00: 00.000"
I would like to convert it to "2018/11/07T00: 00: 00.000"
and then convert it to 07/11/2018 (dd / MM / yyyy)
How can I do ?
01.
<!DOCTYPE html>
02.
<html>
03.
<head>
04.
<base href=
"http://demos.telerik.com/kendo-ui/grid/foreignkeycolumn"
>
05.
<style>html { font-size: 12px; font-family: Arial, Helvetica, sans-serif; }</style>
06.
<title></title>
07.
<link href=
"http://cdn.kendostatic.com/2014.2.716/styles/kendo.common.min.css"
rel=
"stylesheet"
/>
08.
<link href=
"http://cdn.kendostatic.com/2014.2.716/styles/kendo.metro.min.css"
rel=
"stylesheet"
/>
09.
<link href=
"http://cdn.kendostatic.com/2014.2.716/styles/kendo.dataviz.min.css"
rel=
"stylesheet"
/>
10.
<link href=
"http://cdn.kendostatic.com/2014.2.716/styles/kendo.dataviz.default.min.css"
rel=
"stylesheet"
/>
11.
<script src=
"http://cdn.kendostatic.com/2014.2.716/js/jquery.min.js"
></script>
12.
13.
<script src=
"http://cdn.kendostatic.com/2014.2.716/js/kendo.all.min.js"
></script>
14.
</head>
15.
<body>
16.
<script src=
"../content/shared/js/products.js"
type=
"text/javascript"
></script>
17.
<div id=
"example"
>
18.
<div id=
"grid"
></div>
19.
20.
<script>
21.
22.
var
categories = [{
23.
'value'
:
null
,
24.
'text'
:
'null'
25.
},{
26.
'value'
: 1,
27.
'text'
:
'Cat1'
28.
},{
29.
'value'
: 2,
30.
'text'
:
'Cat2'
31.
},{
32.
'value'
: 3,
33.
'text'
:
'Cat3'
34.
}];
35.
36.
37.
38.
$(document).ready(
function
() {
39.
40.
41.
var
date = [{id: 1, name:
"Jane Doe"
, category: 1},
42.
{id: 2, name:
"XXX"
, category: 1},
43.
{id: 3, name:
"XX2"
, category:
null
},
44.
{id: 4, name:
"XXX3"
, category: 1},
45.
{id: 5, name:
"XXX4"
, category: 3}];
46.
47.
var
dataSource =
new
kendo.data.DataSource({
48.
pageSize: 20,
49.
data: date,
50.
schema: {
51.
model: {
52.
id:
"id"
,
53.
fields: {
54.
name: { type:
'string'
},
55.
category: { field:
"category"
, type:
"number"
},
56.
57.
}
58.
}
59.
}
60.
});
61.
62.
63.
64.
$(
'#grid'
).kendoGrid({
65.
dataSource: dataSource,
66.
height: 570,
67.
filterable:
true
,
68.
sortable:
true
,
69.
pageable:
true
,
70.
editable:
true
,
71.
toolbar: [
'save'
,
'cancel'
],
72.
columns: [
73.
{ field:
"name"
, title:
"Name"
},
74.
{ field:
'category'
, title:
'Category'
, width:
'200px'
, values: categories , }
75.
]
76.
});
77.
});
78.
79.
80.
81.
82.
83.
</script>
84.
</div>
85.
86.
87.
</body>
88.
</html>
I am getting Data from Web API as array of object with one of the object's property/field as Date field. on API side its handled and returned as date . But when the data is retrieved after Ajax call , Grid (most likely Javascript as well) treat it as string and grid shows something like "2019-01-01T00:00:00".
I tried to use column.format to display it as date . which doesn't work .
Then i used Template to parse it using kendo.toString which worked,
But when i export grid to Excel or PDF it still shows 2019-01-01T00:00:00
Also i am trying to use Filter option on Column and trying to use Datetimepicker
column.filter.ui ="datetimepicker"
which shows the date picker but filter doesn't work.
Could you please suggest some solution or is there any step i am missing.
Thanks
Hi,
Is it possible to enable dragging of labels so that they don't overlap? See the screenshot for what I mean. I have the chart like that and the labels overlap. Didn't find any way to make them draggable. Or is there any other solution.
Thanks
The strikethrough tool on the toolbar inserts a <del> tag by default. It looks like there may be support for inserting a <strike> tag or a <span style="text-decoration: line-through"> tag as well.
Are those other tags supported? If so, how can I change the default behavior to use one of those instead of the <del> tag.
Hi,
I can show a tooltip, if the mouse hover over a data point: https://dojo.telerik.com/EWoPODum
The tooltip is closed, if the mouse leave the chart or if I click in the chart outside of the bars.
How can I avoid the click? The tooltip should hide if the mouse leave the bar.
Peter