Kendo UI Grid - Filter Integer Column showing as decimal

Question

I am using the Kendo UI (2015.3.930) Grid Control and I have a integer textbox in a grid filter row that always as decimal when I apply the filter.

Here is my code:

@(Html.Kendo().Grid((IEnumerable<UiController.Lot>)Model.Lots)
    .Name("Grid")
    .Columns(columns =>
    {
        columns.Bound(c => c.LotNumber).Title("Lot No")
            .Filterable(ftb =>ftb.ItemTemplate("NumericFilter"));
        columns.Bound(c => c.BranchName).Title("Branch Name");
    })
    .HtmlAttributes(new { style = "height: 530px;" })
    .Filterable(ftb => ftb.Mode(GridFilterMode.Row))
    .DataSource(dataSource => dataSource
        .Server()
        .Model(model => { model.Id(p => p.Id); })
    )
)

My script section shows:

<script>
    function NumericFilter(args) {
        args.element.kendoNumericTextBox({
            "spinners": false,
            "format": "n0",
            "decimals": 0,
        });
    }
</script>

For an integer value of 10, it shows '10.00' after the applying the filter. Is there a way of showing the value without the decimal portion.

Alag · Accepted Answer · 2015-12-28 23:54:43Z

1

I have prepared Dojo example just to show that it is possible.

I have not MVC wrappers but it looks, that it will work if you will do some small modifications to your code:

1] Change ItemTemplate in your Filterable to UI

columns.Bound(c => c.LotNumber).Title("Lot No").Filterable(ftb => ftb.UI("NumericFilter"));

2] Then you should be able to get wanted behaviour with syntax you showed in question with small (selector) modification

<script>
function NumericFilter(args) {
$(args).kendoNumericTextBox({
    "spinners" : false,
    "format": "n0",
    "decimals": 0,
});
}

answered Dec 28, 2015 at 23:54

Alag

1,4081 gold badge17 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Julito Avellaneda · Accepted Answer · 2015-12-29 01:55:43Z

1

to customize this field, you need to use cell.template, please update your code as follow:

columns.Bound(c => c.LotNumber)
    .Title("Lot No")
    .Filterable(ftb => ftb.Cell(c => c.Template("NumericFilter")));

answered Dec 29, 2015 at 1:55

Julito Avellaneda

2,3852 gold badges21 silver badges25 bronze badges

2 Comments

Julito Avellaneda Over a year ago

Great @Luis, please, mark this answer to help other users with this problem.

SeeSharp Over a year ago

and it would be better to use format: "g" in your js function because when textbox loses the focus, it shows a number like 12,345.

Collectives™ on Stack Overflow

Kendo UI Grid - Filter Integer Column showing as decimal

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related