Hi!

I'm using a Grid with a key-based field  with a large list of values.
It works Ok, but when i want to filter by this field, (multi filter) appears hundreds of possible values.

¿Can I reduce the filter values to only existing options in grid elements?

Here is the example:
https://dojo.telerik.com/@larras/atuFikoP

The filter for field country allows all possible values, buy I want to limit the filtering options to the two countries that appear in the grid.

I have tried to use a new reduced collection for values, but in this case, when I add a new row, the country column has not text value and shows the id number.

¿Is possible to change dinamically the "multi" filter collection of values?

Thanks  and greetings!

Hi,

Need to understand how I can get the filter and search features for the Kendo grid to search for strings in child grid rows as well as the parent grid rows... right now if I use the Search window, or the Filter feature at the parent level, the Kendo grid will only search in the domain/area of the parent rows.

How can I include the child rows? This is problematic because, as I understand it the child rows are not loaded until the user clicks the left side triangle icon to open the child rows. Customer wants this.

My understanding is this would require all the child rows to rendered... then searched, and all rows with out the string or or substring would be filtered out?

Before I embark on manipulating the grid, wondered if there was a better solution or way to go about this?

Regards,

George

I have the following kendo grid configuration,

backend service response scheme is correct, but doesnt work the virtual filter. I can't do virtual scrolling

var gridDefinition = {
    model: {
        id: "Id",
        fields: {
            Id: { type: "string" },
            Customer: { type: "string", editable: false },
            //other fields...              
        }
    },
    columns:[
        {
            field: "Customer",
            title: JsonModel.Resources.SAPCustomer,
            filterable: {
                multi: true,
                search: true,
                itemTemplate: function (e) {
                    var customers = $scope.customers || []; 
                    var itemsHtml = "";

                    for (var i = 0; i < customers.length; i++) {
                        var customer = customers[i];
                        itemsHtml += "<li class='k-item'><label class='k-label'><input type='checkbox' name='" + e.field + "' value='" + customer.Id + "'/><span>" + (customer.Description || customer.all) + "</span></label></li>";                                
                    }
                    return itemsHtml;
                }, 
                height: 220,
                virtual: {
                    itemHeight: 26,
                },
                dataSource: {
                    transport: {
                        read: {
                            url: JsonModel.Urls.ListIndexFilterUnique2,
                            type: "POST",
                            dataType: "json",
                            data: function () {
                                return {
                                    ColumnFilter: 'Customer'
                                };
                            }
                        }
                    },
                    requestEnd: function (e) {
                        if (e.type == "read" && e.response) {
                            if ($scope.customers) {
                                $scope.customers = $scope.customers.concat(e.response.customer);
                            } else {
                                $scope.customers = e.response.customer;
                            }
                        }

                    },
                    schema: {
                        data: "model",
                        total: "Total",
                        model: {
                            data: {
                                Id: { type: "string" },
                                Description: { type: "string" }
                            }
                        }
                    },
                    pageSize: 10,
                    serverPaging: true,
                    serverFiltering: true
                },
            },
            headerAttributes: { "class": "kendoui-column-header" }
        },//other columns

Hi All,

My code creates a kendo grid.

When the filterable option is set to true, I see the built-in filter icon on the grid column header and that works fine.

If I set both the filterable:true and columnMenu:true, the filter icon disappears and I see only an icon for the column menu.

I found in the Kendo documentation the below.

When the columnMenu configuration is set to true, the Grid fires the columnMenuInit and columnMenuOpen events instead of filterMenuInit and filterMenuOpen.

Is there a way to have both the filter menu and column menu visible as shown below? Or at least some way when the user clicks on the filter icon to open the filter window? I want the user to be able to filter with one click, instead of clicking on the column menu and then clicking "Filter" to launch the filter screen.

Thank you in advance for any help!

Hi,

I think the filter widget has been omited from the messages file.

I changed the demo code to show that the grid widget getting the messages in the right language (fr-CA) while the filter widget remains in en-US.

Here's the dojo example of the problem.  I alos included a picture.

I took a look at the messages files and only few cultures seems to have implemented the the filter widget messages (ru-RU, zh-CN, zh-HK, zh-TW).

I know I can set my own message thru the filter's configuration messages but ain't that something that should be handled kendo's culture?

Or maybe I'm doing something wrong?

Regards,

Simon

Hello!

Maybe it's a known thing, but I couldn't find a solution. In the grid, I display the data that comes from the server in Windows 1250 format. I display them correctly through the template. But the filtering doesn't work. If I enter a query with special characters, it does not return correct results. It even offers incorrect values (I am sending a picture). I need client side filtering.

Well thank you.

when load 

expected

3 - have ability to make filter simpler(UI, remove group option)

the scenario - I want to have the filter be above the grid & be able to apply the filtering on the server to limit the result set, but at the same time, when the result set is limited give the user the ability to filter the grid on the client using grid row filter