grid number field filter problem, why numerictextbox?

[n/a]

I reposted it with the same title.

[Neli]

Hello,

I tested the behavior in the links provided in the other forum thread regarding the same issue:

- https://www.speedmis.com/_mis/index.php?gubun=1247&isMenuIn=Y

On the screencast linked here, you will find the behavior on my side. As you will see I can successfully enter and filter the data with a number greater than 9000. Could you please let me know if I am missing something? What is the behavior observed on your end?

In addition, I also modified the provided Dojo example and currently, it contains local data in order to have values greater than 9000. However, I can filter the data in the Freight column without any issues. - https://dojo.telerik.com/@NeliKondova/iguboLEB

Looking forward to your reply.

Regards,
Neli
Progress Telerik

[n/a]

Thank you for your reply.

filterable: {
               mode: "row"
},
I'm already know this coding. However, it is not used in the structure I designed. I just want to change it to autocomplete instead of numerictextbox.

The functions I defined are as follows.

>9000 --> price > 9000
>=9000 --> price >= 9000
<9000 --> price < 9000
=9000 --> price = 9000
9000 --> price like '%9000%'
This is not possible with numerictextbox .
So, I would like to change the numerictextbox filter to an autocomplete filter with additional coding.

[Neli]

Hi Won,

If you need to use the AutoComplete for filtering in the Grid filter row you can use the filterable.cell.template option:

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

Here you will find the modified example: https://dojo.telerik.com/@NeliKondova/iguboLEB

Let me know in case you have any addiitonal questions.

Regards,

Neli

[n/a]

Thank you for answer. It is almost the same source as the corresponding source.
The problem is that when onblur, the content blank.

In fact, the solution is to use string instead of number. However, if you use string, sum does not work.

Is it possible to make it not blank even if I onblur it?

 

https://dojo.telerik.com/uvimudIN

 

keyup : good!

 

blue : bad.

 

[Neli]

Hi Won,

The observed issue is due to that you are entering a non-number symbol in a search field for numbers. Thus, the entered values are considered incorrect.

If you try to enter a string '> Ship' for the Ship Name column for example, the value will not disappear on blur as the column is of a string type. 

I am afraid I could not suggest a possible approach for entering special symbols such as '><' for filtering a column of type number.

Let me know in case you have additional questions on the matter.

Regards,

Neli