This question is locked. New answers and comments are not allowed.
Hi,
I have a grid with json kendo datasource .
My date value : Wed Jan 27 2016 15:59:42 GMT+0100 (Romance Standard Time), and in the schema/data/model I specifiy my column type: "date" and in the grid/columns i specify the format: "MM/dd/yyyy", no problem with displaying date in grid, but I want to filter my date without time ,If I pull down the column filter and pick equal to 01/27/2012 nothing shows.
My code :
<code style=
"color: #000;"
>$scope.mainGridOptions = {<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> filter:
"contains"
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> dataSource: {<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> type:
"odata-v4"
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> filter: {<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> logic:
"and"
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> filters: [<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> {<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> field:
"deleted"
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> operator:
"eq"
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> value:
false
<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> }<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> ]<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> },<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> transport: {<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> read: {<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> url: +
'/odata/unites'
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> },<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> },<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> serverPaging:
true
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> serverSorting:
true
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> serverFiltering:
true
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> pageSize: 5<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> },<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> sort: {<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> field:
"id"
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> dir:
"desc"
<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> },<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> schema: {<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> model: {<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> id:
"id"
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> fields: {<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> createdon: { type:
"date"
},<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> titre: { type:
"string"
}<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> }<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> }<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> },<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> groupable:
true
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> sortable:
true
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> filterable:
true
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> pageable: {<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> refresh:
true
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> pageSizes:
true
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> buttonCount: 5<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> },<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> selectable:
true
,<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> <</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> columns: [<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> { field:
"createdon"
, title:
"Date"
, type:
"date"
, template:
"#= createdon ? getDate.formatDate(createdon, 'L') : ''#"
, width:
"50%"
},<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> { field:
"titre"
, title:
"Nom"
, width:
"50%"
}<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> ]<</code><code style=
"color: #069;font-weight: bold;"
>br</code><code style=
"color: #000;"
>> };</code>
Thanks & Regards.