Integer column filter value showing as decimal

[Bob]

Hi, how do I get the numeric textbox in the grid filter row to show integer values for an integer column?  I can apply the filter correctly but after the filter applies it will change "33" to "33.00".

[Kiril Nikolov]

Hello Bob,

You can set format on the filterable on the column like this:

field: "YourField",
filterable: {
        ui: function (element) {
                 element.kendoNumericTextBox({
                     format: "n0"
                 });
             }
        }

Regards,
Kiril Nikolov
Telerik

 

 

[Bob]

Kiril, thanks for reply, but can you provide the syntax for the server-side wrapper?

[Kiril Nikolov]

Hello Bob,

It is practically the same:

.Filterable(f => f.UI("myfilter"));

<script>
function myfilter(element) {
    element.kendoNumericTextBox({
               format: "n0"
        });
}
</script>

Regards,
Kiril Nikolov
Telerik

 

 

[Bob]

This doesn't work as-is when using the filter row.  I was able to verify in the Kendo UI Dojo.  It seemed to work fine for the default filter type though.  Any suggestions?

[Kiril Nikolov]

Hello Bob,

It will not work for the filter row. If you are using the filter row then use the following approach:

http://docs.telerik.com/kendo-ui/api/javascript/ui/grid#configuration-columns.filterable.cell.template

Regards,
Kiril Nikolov
Telerik

 

 

[Bob]

And how do I do this for the paid product (server side)?

[Kiril Nikolov]

Hello Bob,

It is practically the same:

columns.Bound(p => p.Freight).Width(250).Filterable(ftb => ftb.Cell(cell => cell.Operator("gte").Template("foo")))

Where "foo" is the function, behind the template.

Regards,

Kiril Nikolov

Telerik

 

 

[Bob]

If anyone is interested, here's what the filter function I made looks like:

function gridFilterIntegerNumericTextbox(args) {
    args.element.kendoNumericTextBox({
        format: "n0",
        decimals: 0,
    });
}

[Deepti]

Could you please share the complete code snippet that how you have used it?

[Petar]

Hi Deepti,

As the last reply in this thread is from 2015 and may be outdated, can you specify what functionality do you want to implement for the Grid component?

What 'complete code snippet' do you need?  

Regards,
Petar
Progress Telerik

[Bermuda]

Hi - Hope this code example helps someone in the future. 

//Kendo Grid
columns.Bound(p => p.Id).Title("ID").Filterable(f => f.UI("onIntFilter"));

<script>

	function onIntFilter(e) {
		e.element.kendoNumericTextBox({
			format: "n0",
			decimals: 0,
		});
	}
</script>