Can I Apply cast datatype for Filter!

[The GridLock]

Hi,

As far as I remember, when using the columns.filter function, if the data types are not identical (for example the column has concurrent strings and numbers) then the filter will fail because in each code only one strongtype or StringTyped is allowed.

Is it possible to cast these data types to ignore the error?

column example

1

2

3

a

b

5

.FilterPredicates.Add (New FilterPredicate () With {

                                                    .FilterBehavior = ftbehav,

                                                    .FilterType = FilterType.greater,

                                                    .FilterValue = 2})

how to select filterbehavior to get result:

3

5

[Vijayarasan Sivanandham]

Hi Khanh Dang,

Thank you for contacting Syncfusion support.

Based on provided information in your filter predicates contains the FilterType as Greaterthan in mentioned column does not apply the greater than in string type value. In this case not applied in the filter row.

Please let us know, if you require further assistance on this.

Regards,
Vijayarasan S

[The GridLock]

Hi Vijayarasan ,

I mean, the current filter will only allow us to do filtering on columns of the same data type.

Will you expand this functionality in the future? the filter function will check the types first and return the results after being cast though it may be slower but safer and easier to use

[Vijayarasan Sivanandham]

Hi Khanh Dang,

Thanks for the update.

We also regret to inform you that​​​ currently, Our SfDatagrid source architecture does not provide support to achieve your requirement of “the filter function will check the types first and return the results after being cast in SfDataGrid”. 

Regards,
Vijayarasan S 

[The GridLock]

Ok Vijayarasan!

[Vijayarasan Sivanandham]

Hi Khanh Dang,

 

Thanks for the update. 

 

Please let us know if you have any further queries on this. We are happy to help you😊. 

 

Regards, 

Vijayarasan S