This is a migrated thread and some comments may be shown as answers.

Grid Filters with Date

2 Answers 77 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Hayfa
Top achievements
Rank 1
Hayfa asked on 04 Feb 2016, 11:26 AM

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.

2 Answers, 1 is accepted

Sort by
0
Hayfa
Top achievements
Rank 1
answered on 04 Feb 2016, 11:31 AM
[quote]Hayfa said:

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 :

$scope.mainGridOptions = {
        filter: "contains",
        dataSource: {
            type: "odata-v4",
            filter: {
                logic: "and",
                filters: [
                    {
                        field: "deleted",
                        operator: "eq",
                        value: false
                    }
                ]
            },
            transport: {
                read: {
                    url: MyUrl+ '/odata/unites',
                },
            },
            serverPaging: true,
            serverSorting: true,
            serverFiltering: true,
            pageSize: 5
        },
        sort: {
            field: "id",
            dir: "desc"
        },
        schema: {
            model: {
                id: "id",
                fields: {
                    createdon: { type: "date" },
                    titre: { type: "string" }
                }
            }
        },
        groupable: true,
        sortable: true,
        filterable:true,
        pageable: {
            refresh: true,
            pageSizes: true,
            buttonCount: 5
        },
        selectable: true,
       
        columns: [
            { field: "createdon", title:"Date", type: "date", template: "#= createdon ? getDate.formatDate(createdon, 'L') : ''#" , width:"50%" },
            { field: "titre", title: "Nom", width: "50%" }
        ]
    };

Thanks & Regards.
[/quote]
0
Tsvetina
Telerik team
answered on 09 Feb 2016, 08:07 AM
Hello Hayfa,

Please note that this is the Telerik Platform forum where problems related to the Telerik Platform products and services only are discussed. You can post in the Kendo UI forums or Stack Overflow to enquire about Kendo UI. 

Also, a quick search produced this result, so you can check it out before opening a new thread:
Display Kendo Grid column as DateTime but ignore Time when filtering


Regards,
Tsvetina
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
General Discussions
Asked by
Hayfa
Top achievements
Rank 1
Answers by
Hayfa
Top achievements
Rank 1
Tsvetina
Telerik team
Share this question
or