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

Grid search filtering in official release

10 Answers 425 Views
Grid
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Joel
Top achievements
Rank 1
Joel asked on 29 Nov 2011, 08:49 PM
Just wondering if the Grid widget will have search filtering integrated into it for the official release?

10 Answers, 1 is accepted

Sort by
0
Joseph Guido
Top achievements
Rank 1
answered on 02 Dec 2011, 02:57 PM
I'm looking for the same feature!
0
James
Top achievements
Rank 1
answered on 04 Dec 2011, 12:17 AM
Same here. I'm very curious if/when this feature may be implemented.
0
Atanas Korchev
Telerik team
answered on 05 Dec 2011, 11:16 AM
Hello,  

Filtering is already supported. Check this example. To enable the filtering you need to do the following:

  1. Make the grid filterable:
    filterable: true
  2. Configure the model of the datasource (required to determine the type of the column:
    dataSource: {
        data: createRandomData(50),
        schema: {
          model: {
              fields: {
                FirstName: { type: "string" },
                LastName: { type: "string" },
                City: { type: "string" },
                Title: { type: "string" },
                BirthDate: { type: "date" },
                Age: { type: "number" }
              }
        }
        }
    }

 Regards,
Atanas Korchev
the Telerik team
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0
Greg
Top achievements
Rank 1
answered on 05 Dec 2011, 05:49 PM
Hi Atanas,

The kind of filtering that my users prefer is a very simplified one, ala jquery datatables (http://datatables.net/). The filtering implemented for grid is certainly useful for someone like an excel power user. For the more casual user, it's a bit tedious to enter filter criteria column-by-column.

From a developer's perspective, the filtering you have implemented is great work!

Thanks for listening,

-Greg
0
Joseph Guido
Top achievements
Rank 1
answered on 05 Dec 2011, 07:07 PM
I need additional features that are not included in the Grid.  I would like to discuss my requirements and see if and how they could be meet. 

Can the framework be extended or would this be an enhancement request?
0
James
Top achievements
Rank 1
answered on 05 Dec 2011, 09:45 PM
That's exactly what I had in mind too, Greg. It's not clear if it's a simple matter to build a search field that allows filtering of rows displayed in the grid based on an almost auto-complete style of entry.
0
Atanas Korchev
Telerik team
answered on 06 Dec 2011, 09:40 AM
Hello,

 The Kendo DataSource has a rich filtering API which can be used to filter any bound UI widgets. Here is a demo showing how to implement filtering with a dropdownlist:
http://demos.kendoui.com/web/grid/toolbar-template.html

Regards,
Atanas Korchev
the Telerik team
Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
0
Greg
Top achievements
Rank 1
answered on 08 Dec 2011, 12:34 PM
Atanas, thanks for that example - that does go a long way to getting me what I would like to see. Looking at DataSource, it does look like a free-text filter can be implemented. I'll give it a shot and see what I can come up with. The other thing my users like is the ability to export the filtered data in tab separated text or pdf format - we use a DataTables plugin for that now. I think I'm getting into feature request territory now which is probably beyond my open-source license agreement ;-)
0
Conor
Top achievements
Rank 1
answered on 04 Apr 2012, 03:13 AM
Hi all, 

just wondering whether anyone ever implemented a global search feature? The best table filtering option I have ever seen has been in Datatables, whereby every cell in the table is queried compared and then returned, but I haven't found any way of replicating this yet with Kendo. Any ideas?

Conor
0
Danny
Top achievements
Rank 1
answered on 03 Aug 2012, 09:44 AM
I second this! I am also trying to find a way to search all the columns of the grid in a 'Datatables'-like way. Would be a great plus if it were to be made possible with Kendo, because i think Kendo is superior in every other way. Would hate to not be able to use Kendo because of the lack of global search filtering.
Tags
Grid
Asked by
Joel
Top achievements
Rank 1
Answers by
Joseph Guido
Top achievements
Rank 1
James
Top achievements
Rank 1
Atanas Korchev
Telerik team
Greg
Top achievements
Rank 1
Conor
Top achievements
Rank 1
Danny
Top achievements
Rank 1
Share this question
or