Filter numeric value as string

Kinetic ERP
1

I just added an Idea to the Epicor Ideas Portal…

When filtering a grid for a numeric value, the mathematic operators are available such as (not) equal to, greater/less (or equal) than, between, etc. For particular numeric fields, such as Sales Order number, Purchase Order Number, it would be beneficial to type only the last few digits of the number and find matches. This would be done by searching the numbers as converted to a string value and performing a “contains” search on the conversion. This would still allow the column to use the right-click → Open With functionality.

https://epicor-manufacturing.ideas.aha.io/ideas/KIN-I-4395

image

2

Could this be done by creating a BAQ Search or QuickSearch and apply that programming to the Search in the BAQ Code?

I recall they used to have a “Custom” in the Filter where you could put SQL Code.
Just an idea.