We have a challenge with OData V4 webservices.
We have exposed the Sales Price table (7002) as webservice through a custom page object. For example we want to show all the Sales Price records where Starting Date is empty/0D.
I have tried several ways to filter on empty dates in the OData filter but or the webservice return no records or all records.
$filter=Starting_Date eq null – return all records, don't take into account the Starting_Date filter
$filter=Starting_Date eq 'null' – return an error because incompatible types (Edm.Date, Edm.String)
$filter=Starting_Date eq '' – return an error because incompatible types (Edm.Date, Edm.String)
$filter=Starting_Date eq 0001-01-01, in the output empty / 0D displayed as 0001-01-01 but you can't filter on this value
$filter=Starting_Date eq 1753-01-01, SQL min date return no results
Hopefully there is any solution for this or has anyone experience with it!