Grid Filtering on Decimal Column

[Craig]

For anyone who can help - I'm having an issue with the grid's ability to filter on a field that is of the type decimal. 

Here's what my filter looks like:

restFilter.filters.push({ field: "OrderNumber", operator: "eq", value: searchValue });

Error: Message"The binary operator Equal is not defined for the types 'System.Decimal' and 'System.String'."string

Not sure what to do, any ideas?

Thanks!

Craig

 

 

[Viktor Tachev]

Hi Craig,

Similar error to the one you are seeing have been reported in the EntityFrameworkCore repository. If you are using EntityFramework Core please update to the latest version and see how the behavior changes. 

An alternative approach would be to change the type of the OrderNumber field to something else - e.g. long.


Regards,
Viktor Tachev
Progress Telerik

[Craig]

Thank you Viktor! That upgrade for EF Core worked like a charm. Appreciate the help and the awesome turnaround time. Thanks again, Craig