web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Client requests for Query objects using OrderBy are not supported by OData web services

(0) ShareShare
ReportReport
Posted on by

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.

  dataitem(Resource; Resource)
        dataitem(Dimension_Value; "Dimension Value"
            
I have the same question (0)
  • Verified answer
    Lars Lohndorf-Larsen Profile Picture
    Microsoft Employee on at

    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?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,273 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,669 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,402

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans