Grid - Filter - Standard Drop down first actual filtered results

[Peter]

Please correct me if I am wrong.   When we try to search in the Name field (without tabbing out), a drop down appears, but only appears to use StartsWith.  While when you tab out, the filtering actually uses the filter operator.

Other than wiring up a filter template to a combobox and then wire up to the "Operator button" (change event) make sure the Grid Filter operator matches the Combobox operator, is there anything else I can do?

Thanks

Sample code below: 

                    @(Html
                .Kendo()
                    .Grid<ItemViewDisplay>()
                        .Name("saleItemSearchGrid")
                        .Columns(columns =>
                        {
                            columns.Bound(c => c.ItemCostId).Hidden(true);
                            // Name:
                            columns.Bound(c => c.Name).Filterable(KendoConstants.Grid.FilterConfigs.ContainsOperator);
                            // IngredientNumber:
                            columns.Bound(c => c.IngredientNumber).Filterable(KendoConstants.Grid.FilterConfigs.ContainsOperator);
                            // BarcodeCount:
                            columns.Bound(c => c.BarcodeDisplayList).Filterable(f => f.Cell(cell => cell.Operator("contains").Delay(1500)))
                       .ClientTemplate("#=BarcodeDisplayStr#");
                            columns.Command(command => { command.Custom("gridSelect").Text("Select").Click("jsSaleItemSelected"); }).Title("Action");
                        })
                        .HtmlAttributes(KendoConstants.Grid.StandardHtmlAttributes)
                        .Scrollable()
                        .Sortable()
                        .PersistSelection()
                        .Filterable(KendoConstants.Grid.FilterByRow)
                        .Pageable(KendoConstants.Grid.Paging5Button)
                        .DataSource(dataSource => dataSource
                            .Ajax()
                            .Events(KendoConstants.StandardErrorFunction)
                            .Model(model => model.Id(p => p.ItemCostId))
                            .Read(read => read.Action("MenuButtonItemList_Read", "Menu"))
                            .PageSize(KendoConstants.Grid.StandardPageSize)
                        )
                    )

[Angel Petrov]

Hi Peter,

If you want to only change the operator in the dropdown you can use the SuggestionOperator as shown below.

columns.Bound(p => p.ShipName).Filterable(ftb => ftb.Cell(cell => cell.SuggestionOperator(FilterType.Contains))).Width(500);

With the above approach there is no need to create a custom filter control to replace the default one.

Regards,
Angel Petrov
Progress Telerik

[Peter]

That applies to the Filter in the grid, I am referring to the drop down that appears before the change event in the filter box is triggered and the grid is updated.

[Peter]

See the sample

[Angel Petrov]

Hi Peter,

Actually the SuggestionOperator is related to the dropdown. The cell operator is related to the grid. Here is a configuration demonstrating both of them.

columns.Bound(p => p.ShipName).Filterable(ftb => ftb.Cell(cell => cell.Operator("endswith").SuggestionOperator(FilterType.Contains)));

Regards,
Angel Petrov
Progress Telerik

[Peter]

Thanks for that clarification, is there anyway to keep the drop down and grid filter operators in sync?

[Angel Petrov]

Hello Peter,

By in sync I suppose that you mean to use equal operators. Currently this is achievable only if the operators are Contains and StartsWith as the SuggestionOperator can be set to one of the aforementioned. If the requirement is to have all the operations listed I suggest opening a feature request.

Regards,
Angel Petrov
Progress Telerik