Problem with orderby in Odata query

(1) Share

Report

Posted on by Shooowtek

843

Hello,

I am trying, using orderby, to sort the received data from OData.
However, it is not working for me - doesn't sort..

I using:

[*d365URL*]/data/[*data entity collection name*]?&orderby=[*field*]

Is this no longer supported?

https://learn.microsoft.com/en-us/openspecs/windows_protocols/ms-odata/793b1e83-95ee-4446-8434-f5b634f20d1e

Thanks.

I have the same question (0)

All responses (7)

Answers (1)

CS-15051251-0 20 on at

Like (0)

Report

Problem with orderby in Odata query

Hey All,

I came across this issue with a client using the "General Ledger Entries" Page 20 as an OData data source. After some testing, I have learned that $orderby will not work when the data source is a page that has default sorting defined by the SourceTableView property.

Thanks

Was this reply helpful? Yes No
Verified answer

huijij 19,811 on at

Like (0)

Report

RE: Problem with orderby in Odata query

Hi Shooowtek,

The orderby query is supported, I noticed that you have used the wrong symbols. Please try with the symbols ‘$’ again.

[*d365URL*]/data/[*data entity collection name*]?$orderby=[*field*]

Was this reply helpful? Yes No
Shooowtek 843 on at

Like (0)

Report

RE: Problem with orderby in Odata query

How is the data sorted by default in the data entity?

Was this reply helpful? Yes No
Shooowtek 843 on at

Like (0)

Report

RE: Problem with orderby in Odata query

Unfortunately it doesn't work on my custom data entity.

Does anyone have any suggestions?

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

RE: Problem with orderby in Odata query

I have tried with my custom Data entity and sorted on Qty field and it worked perfectly fine. I don't think there is any extra setting or property required.

Was this reply helpful? Yes No
Shooowtek 843 on at

Like (0)

Report

RE: Problem with orderby in Odata query

Hello,

I can see that sorting does not work on custom data entities..

I tried comparing my entity to standardoywch, but found nothing. Is some settings responsible for OData sorting? Or maybe the custom tables I created don't have the right settings?

Thanks.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,563 Moderator on at

Like (0)

Report

RE: Problem with orderby in Odata query

Hi, I have tried below query, Orderby is working as expected

xxxxxx.sandbox.operations.dynamics.com/.../CustomerGroups

Was this reply helpful? Yes No

Community site session details

Problem with orderby in Odata query

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

Problem with orderby in Odata query

Helpful resources

News and Announcements

Quick Links

Responsible AI policies

Andrés Arias – Community Spotlight

Congratulations to the August Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates