While migrating some form logic which used to execute a FetchXML query and react to the result accordingly, from XrmServiceToolkit to the native OData Web API in 8.2, I encountered some weird platform behaviour. Everytime the LIKE
filter condition contained a part of the number series 123456789
beginning at number 1
(like for example %123%
), the OData service yields a 500
server error for no obvious reason.
This bug was solved in latest 9.1 version (or earlier), event in the Web API endpoint version 8.1
- Build FetchXML query which contains a
LIKE
filter with an arbitrary substring of the number series123456789
beginning at first digit - Send a RetrieveMultiple request using previously created FetchXML query to Web API