Problem with orderby in Odata query

(1) Share

Report

Posted on by Shooowtek

845

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)

Sort by

Suggested answer

Mohit Rampal 12,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

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

Was this reply helpful? Yes No
Shooowtek 845 on at

Like (0)

Report
Copy link

Link copied!

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,573 Moderator on at

Like (0)

Report
Copy link

Link copied!

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 845 on at

Like (0)

Report
Copy link

Link copied!

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

Does anyone have any suggestions?

Was this reply helpful? Yes No
Shooowtek 845 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

huijij 19,811 on at

Like (0)

Report
Copy link

Link copied!

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
CS-15051251-0 59 on at

Like (0)

Report
Copy link

Link copied!

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