Search box on grid with non string types

[Brian]

ASP MVC Core grid with the search box enabled.  Per the docs I turned server operation to 'false' and from what I have read this should then allow searching for more that just string types.  In the below example 'PaymentType' is an enum and the search box does not work when searching for that.  It also does not work for the formatted date. 

I could change the datatypes to string but then it might break ordering columns that are DateTime types.

 

    @(Html.Kendo().Grid<B3.Services.LoanServices.LoanServiceModels.PaymentServiceModel>()
        .Name("PaymentRegisterReport")
        .DataSource(dataSource => dataSource
            .Ajax()
            .Read(read => read.Action("Payments_Read", "StandardReports", new { area = "Reports" }))
            .PageSize(1000)
            .ServerOperation(false)
        )
        .Columns(columns =>
        {
            columns.Bound(p => p.Date).Format("{0:MM/dd/yyyy}").Title("Date");
            columns.Bound(p => p.LoanName).Title("Loan Name");
            columns.Bound(p => p.PaymentType).Title("Payment Type");
            columns.Bound(p => p.CheckNumber).Title("Check Number");
            columns.Bound(p => p.Amount).Title("Amount").Format("{0:C}")
                .HtmlAttributes(new { style = "text-align: right" }).HeaderHtmlAttributes(new { style = "text-align: right" });

        })
        .Pageable()
        .Sortable()
        .Filterable()
        .HtmlAttributes(new { style = "font-size:12px" })
        .ColumnMenu()
        .ToolBar(t =>
        {
            t.Search();
            t.Excel();
        })
        .Reorderable(l => l.Columns(true))
        .Events( e =>
        {
            e.ColumnShow("saveKendoGridState");
            e.ColumnHide("saveKendoGridState");
            e.ColumnReorder("kendoGridColumnReorder");
        })
    )

 

 

[Eyup]

Hello Brian,

 

The Search panel input uses the "contains" filter function, therefore, it is generally suitable for string columns. Here you can find its full code:
https://docs.telerik.com/kendo-ui/knowledge-base/grid-search-panel-with-multiple-values

In this sense, you can try either of these options to resolve this:

1. Override the built-in behavior as demonstrated in the KB above

2. Implement your own Search input:
https://docs.telerik.com/kendo-ui/knowledge-base/filter-all-columns-with-one-textbox

 

Regards,
Eyup
Progress Telerik

[Brian]

Per the comment from Alex on October 17 2019, I read this as if server filtering is set to false then it should work with all types.  Am I reading this incorrectly?

https://www.telerik.com/forums/new-search-panel-and-datetime

[Alex Hajigeorgieva]

Hi, Brian,

Just a quick note to update the forum thread here.

After further discussion, we have opened a feature request on your behalf that will allow users to search by the text of the enums instead of their values as it is now with ServerOperation(false).

For more information and to upvote the feature request, go to:

https://feedback.telerik.com/aspnet-core-ui/1502963-grid-search-panel-with-text-instead-of-value-for-enum-types

Kind Regards,
Alex Hajigeorgieva
Progress Telerik