
Hi all,
i have a query in NAV 2015 that work fine, but in BC Onpremise 17 return the error 'Client requests for Query objects using OrderBy are not supported by OData web services' when i call it with Odata.
The error occurs when i set a $top parameter. If i run the query whitout parameters works fine.
No errros if i run in OdataV4.
The query it's simple and have a Dimension Value linked.
Hi Luca,
At some point the OData filtering was changed to be apparently more compliant but also more restrictive. To set behaviour back to how it was, you could set this in NST Config:
<add key="EnableODataStrictFiltering" value="false" />
But I don't think this is valid anymore in BC17 - probably only until around NAV2017/2018. If you are on BC then odata is about to expire anyway, so I would move forward with OdataV4 if possible, or API.
I hope this helps?