String filtering with Ax7 oData gives error

Question

I am trying to use the Ax7 oData endpoints to search for sales quotations by Name. Using equality works just fine, but the more advanced filter functions gives me errors.

This simple EQ query works OK: https://myAx7Server/data/SalesQuotationHeaders?$filter=SalesQuotationName eq 'Sparrow Retail'

But this query gives me the error "The type 'System.String' for the query operator is not Queryable!"

https://myAx7Server/data/SalesQuotationHeaders?$filter=startswith(SalesQuotationName,'S')

Am I doing something wrong, or is it just that these oData endpoints do not support searching by string?

Answer 1

Found the answer here: https://ax.help.dynamics.com/en/wiki/dynamics-ax-7-services-technical-concepts-guide/#odata-services

This is implemented as a wildcard character Example: http://host/service/EntitySet?$filter=StringField eq '*retail*'