Numeric column filter format

[Chris]

Hi,

I'm trying to format the filter control for an integer column to not use decimals, separators or spinners. I'm using Kendo.Mvc version 2017.1.118.545.

Using the answer from another question I've tried the following approach:

c.Bound(m => m.Id)
  .Title("ID")
  .Filterable(ftb => ftb
    .Cell(cell => cell
      .Operator("eq")
      .ShowOperators(false)
    ).UI("integerFilter"));

 

function integerFilter(el) {
  el.kendoNumericTextBox({
    spinners: false,
    format: "#",
    decimals: 0
  });
}

 

However as per attached screenshot, this doesn't work.

Please advise how to achieve this behaviour as according to the API guide (and other questions), this is correct.

 

Thanks,

Chris

[Preslav]

Hello Chris,

To overcome this, use the columns.filterable.cell.template configuration instead of the columns.filterable.ui. More information about this is available in the relevant API Reference:

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

Now, The code should look like:

.Filterable(ftb => ftb
    .Cell(cell => cell
        .Operator("eq")
        .ShowOperators(false)
        .Template("integerFilter")
    ))

function integerFilter(e) {
    e.element.kendoNumericTextBox({
        spinners: false,
        format: "#",
        decimals: 0
    });
};

I hope this helps.


Regards,
Preslav
Progress Telerik

[Chris]

Thank you Preslav that's removed the separators, decimals and spinners.

 

Please could you advise if it's possible to include the clear X button like the regular filter inputs?

[Preslav]

Hi Chris,

The X button is hidden by default, however, when the user inputs a value, it should appear.

For example - https://www.screencast.com/t/xhTQ5x64

If this is not the case on your side, could you please share a runnable project that demonstrates the behavior? This will help me fully understand the case and I will be able to provide further assistance.


Regards,
Preslav
Progress Telerik