You cannot filter on a Number type attribute
within an Entity view on the MDM web interface
You will get "The number is not valid." error message in red
Once you have selected an attribute filter that has Numeric data type.
You can type a value in the Criteria box, but the “Apply” button
Is not clickable.
If you press F12 in Chrome and enter a numeric value in the
Criteria text box and press tab, you will see the exception below:
KoFilterView.js:459 Uncaught ReferenceError: isInteger is not defined
at filterLine.checkValue (KoFilterView.js:459)
at dbaPicker.self.onfocusout (KoDbaPicker.js:555)
at HTMLInputElement. (knockout.js:79)
at HTMLInputElement.dispatch (jquery.js:4409)
at HTMLInputElement.elemData.handle (jquery.js:4095)
filterLine.checkValue @ KoFilterView.js:459
self.onfocusout @ KoDbaPicker.js:555
(anonymous) @ knockout.js:79
dispatch @ jquery.js:4409
elemData.handle @ jquery.js:4095
...\Master Data Services\Web Application\Scripts\UserControls\KoFilterView.js
Replace
if (isInteger(value - 0)) {
with
if (Number.isInteger(value - 0)) {
afterward, clear the browser cache.
The fix works only for Chrome and doesn't work in Internet Explorer
In my case, you will still see the red error message
but the “Apply” button will become clickable and you will be able
to filter on numeric values.
Enjoy :)
Hi, thanks a lot for this fix!
ReplyDeleteBut, I still have a problem with filtering numeric values by 'is NULL' and 'is NOT NULL'. Do you by any chance know the solution to this issue as well?