My attempt to execute a query with a filter on a string column is running into issues. Some filter values, like 'PO Box 27', are causing the queries to fail at runtime. The error message I receive states: "The string 'PO Box 27' is not a valid TimeSpan value."
Here is the code snippet:
var crmAccountsQuery = EntityQuery
.from('crmAccountEFs')
.where(breeze.Predicate.create('address1_Line1', 'eq', 'abc'));
Upon attempting to filter using this query structure, it fails and throws an error message.
The breeze.js library on the client side generates a URL like:
http://localhost:49800/breeze/BreezeDb/crmAccountEFs?$filter=(Address1_Line1%20eq%20time'PO%20Box%2027')
It seems that there is a mismatch in data typing.
Edit: related link: BreezeJS malformed OData query Url when using "startsWith"