Order by an entity

(0) Share

Report

Posted on by Evi

Hello everybody,

I have a scenario where one custom entity(previously created by some other developer) when exporting data it automatically orders the data by one of the fields(ItemId in this case). And I don't need this order by.

I have studied the entity, but I cannot find any order by in the code or the entity.

I have even searched online to find where the entity gets ordererd by, but cannot find anything.

I am using D365 F&O.

I wanted to ask if is there any place where the entity that does the order by?

Thanks in advance!

All responses (4)

Answers (1)

Verified answer

Martin Dráb 230,149 Most Valuable Professional on at

Like (0)

Report

Order by an entity

If no order is specified when querying the view, the database server can return the data in any other it finds appropriate. For example, if the entity is based on a single table, I would expect records in the order of the clustered index. But it's not guaranteed.

If you're saying that you don't need particular ordering, then you don't need to do anything.

(Moved from D365 general forum.)
Evi 8 on at

Like (0)

Report

Order by an entity

I am using D365 F&O.
Hana Xue Microsoft Employee on at

Like (1)

Report

Order by an entity

Hi,
Please clarify which product you are using so we can direct you to the right place.
Best Regards,
Hana
Martin Dráb 230,149 Most Valuable Professional on at

Like (1)

Report

Order by an entity

D365 consists of many applications, such as Finance and Operations, Sales or Business Central. You're asking in D365 general forum, therefore it's not clear which product you have in mind. Please add this information.