Forum Discussion
How to remove (Blank) value using URL Filtering
Hi MetrumOBE,
Maggie Replied my that the writer of the online document.
It looks like it depends on the data type. Doing filter=Table/Column ne ‘’ will work if Column is a string type. But this doesn’t work for numbers or dates since it is trying to compare invalid data types to the empty string.
Our parser doesn’t have support for null as a right hand side expression, but we can add that functionality as part of the OData improvements after the accessibility work is finished. But for now this would only work for string values. There is a workaround by doing something like (filter=Table/Num gt L) where L is the lowest number in their dataset (or use “lt” and the value would be the largest number in that column). This would filter out empty values but you would need to know the high/low bounds of your dates and numbers.
Regards,
Frank
Hi MetrumOBE,
Based on my test, we cannot filter the blank value using this way directly. However we can create a calculated column in your data model switching the target column to numbers. Then we can use 'ge' to work around.
?filter = table/column ge number
For more details, please check the online document.
Regards,
Frank