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,
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,
Thank you very much for your help.
The current field is in type String so it should work with ne ''.
But, when I tested it it didn't.
I would try maybe another approach on this.
I already though about your workaround proposal, I will test it.
It could be a good improvement for URL filtering for next release ;).
Many thank you.
Olivier