I have a very standard Database with a COLUMN that is a bool(bit type) on SQLAzure ODATA enabled db.
however using the below filter logic on the URI returns no results. I can easily filter for other types... but for some reason my boolean filters do not work on my DB.
...........?$filter=COLUMN eq true
I have tried on the cloud Northwind as below with success.
http://services.odata.org/Northwind/Northwind.svc/Categories(2)/Products?$filter=Discontinued eq true
So I'm wondering what the difference is.
Is there a known bug or problem with filtering for booleans on Labs SQLAzure OData enabled DB?