Filter Row Textbox for Int column with no decimals

[Frans]

Hi,

Im am working on a grid with some Integer data columns in it (like customer Id), including filtering in the top row of the grid (thus with.Filterable(ftb => ftb.Mode(GridFilterMode.Row)); )
By default, I see decimals in the filter textbox, like 16.00.

How can I remove those decimals (just plain int) ? So that I see just 16 instead of 16.00.

I tried a lot. Like setting format to "#", "N0", "n0", "0:N0", "0:n0", etc. Also a suggestion about a javascript function coupled. But nothing seems to work.

My code is now something like this:

columns.Bound(colInfo.Name)
                        .Title(colInfo.Title)
                        .Width(colInfo.PixelWidth)
                        .Format(colInfo.DataFormat)
                        ;

 

best regards,

Martin

 

[Eyup]

Hello Martin,

 

Thank you for writing to us.

There are 2 ways of achieving this requirement:

1. Creating a template:
- https://docs.telerik.com/kendo-ui/api/javascript/ui/grid/configuration/columns.filterable.cell#columnsfilterablecelltemplate

- https://docs.telerik.com/aspnet-core/api/Kendo.Mvc.UI.Fluent/GridColumnFilterableCellSettingsBuilder#templatesystemfuncsystemobjectsystemobject

2. Accessing the generated numbox manually via javascript and removing the decimals by re-creating the widget:
https://docs.telerik.com/kendo-ui/api/javascript/ui/numerictextbox/configuration/decimals

Feel free to give it a try and let me know how it goes.

 

Regards,
Eyup
Progress Telerik

[Frans]

Thanks Eyup,

Those solutions might work, but I want it simpler. 

I dont want to mess with jQuery or css, I just want a serverside property where I can simply set this number of decimals.

Its just too trivial to do it in such a inefficient way.

 

best regards,

Martin

 

[Frans]

Hi Eyup / Telerik,

I found a working solution in another thread. This code below worked for me.

However, I still think this should become simpler. As a .Net MVC developer, you want to code and tweak as little as possible in jQuery, kendo client lib, and css.
I think a Integer column should have 0 decimals by default in the filter row. Without any hassle with clientcode like this.

------------------------------------------------------------------------------------
MVC Serverside code

 columns.Bound(colInfo.Name)
                            .Filterable(ftb => ftb
                                .Cell(cell => cell
                                .Operator("eq")
                                .ShowOperators(false)
                                .Template("integerFilter")
                            ))
                            .Title(colInfo.Title)
                            .Width(colInfo.PixelWidth)
----------------------------------------------------------
With js file:

// Needed for Telerik Grid number column with no decimals (Integer)
function integerFilter(e) {
    e.element.kendoNumericTextBox({
        spinners: false,
        format: "#",
        decimals: 0
    });
};

[Eyup]

Hello Frans,

 

I am glad that you've managed to resolve the issue with a more preferable approach. Thank you for sharing it with our community.

Exposing this setting on the column level is a nice idea and you can log it in our Public Portal for more traction:
https://feedback.telerik.com/aspnet-mvc

 

Regards,
Eyup
Progress Telerik