Supply chain | Supply Chain Management, Commerce

How to sort data on Odata

(0) Share

Report

Posted on by Community Member

I am working on Odata. I have created data entity to show sales order line item.

I am trying to sort Odata details based on datasource "InventTrans", "Qty" field.

It would be a great help if you provide me solution (how to sort data based on datasource "InventTrans", "Qty" field --> Odata sort the deatils based on InventTrans "Qty." field )

OData datasource structure:

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Martin Dráb 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
What you're looking at is a data entity definition, not OData services.

If you want to use OData to sort by InventTrans.Qty, expose this data source field as an entity field. Let's say it'll be called InventTransQty. Then you can use an OData query like this:

https://myAx.cloudax.dynamics.com/data/MyLines?$orderby=InventTransQty

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thanks Martin.

I am looking to sort data at data entity level. Below example, I wants to show on Odata

Example: 1 line with 10 qty. breaks into three line and we have displayed these breaks qtys. using "InventTrans" table

on the inventTrans datasource levels we want to sort "inventTrans" details.

Was this reply helpful? Yes No
Martin Dráb 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

I don't think what you ask for is possible. Ordering is what you do by a query and when you want to do it via OData, you have the solution in my previous reply.

Was this reply helpful? Yes No
Yoko Isono Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Unfortunately the sort feature of entity data is not provided for now, because it requires a lot of resources and can impact system performance.
We are recommended to export entity data to SQL database by BYOD etc. once and execute sorting if needed.

Was this reply helpful? Yes No
Martin Dráb 239,029 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

What is the source of this information? I can't confirm it - sorting does work for me.

Was this reply helpful? Yes No
Suggested answer

Rahul Mohta 21,042 on at

Like (0)

Report
Copy link

Link copied!

while calling , could use the option to retrieve sorted data using $orderby

see if this helps

docs.microsoft.com/.../odata

Was this reply helpful? Yes No