Customer experience | Sales, Customer Insights,...

How to sort the entity collection order by descending of created on date in plugin.

(0) Share

Report

Posted on by Community Member

We have a requirement where we need to sort the entity collection in descending order by date in plugin . Can someone help me how to do that?

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Guido Preite 54,086 Moderator on at

Like (0)

Report

why don't configure the view where the data will be shown to be sorted by the date? you don't need to implement this logic inside a retrievemultiple plugin

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

We want to set the entity collection (this data is coming from fetch xml aggregate query) data to the virtual entity . So for this we need to have entity collection before running this following code , we need to sort this Entity collection order by date descending.

context.OutputParameters["BusinessEntityCollection"] = entityCollection;

And with the help of view it is not possible.

Was this reply helpful? Yes No
Suggested answer

Guido Preite 54,086 Moderator on at

Like (0)

Report
the entityCollection in your line of code is probably defined as

EntityCollection entityCollection = new EntityCollection();

if you define your records like

List entities = new List();

you can do this line to add the entities like

entityCollection.Entities.AddRange(entities);

so you just need to sort (with LINQ) the List<Entity> with your criteria.

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

Try below code

var responseRoomAllocDetails=roomAllocDetails.Entities.OrderByDescending(x => x.Attributes["createdon"]).Select(x => x);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

var responseRoomAllocDetails = entityCollection.Entities.OrderByDescending(x => x.Attributes["pp_lastlogindatetime"]).Select(x => x);

context.OutputParameters["BusinessEntityCollection"] = entityCollection;

This code is not showing any error , but what i am trying to achieve is still not achievable for me

Was this reply helpful? Yes No
Suggested answer

Bipin D365 28,983 Moderator on at

Like (0)

Report

Hi,

It is not working because you are passing original EntityConnlection object to output parameter

You need to do as below

var entityCollection = new EntityCollection<TEntity>();

foreach (var item m in list)

{

entityCollection.Add(m);

}

Replace list with responseRoomAllocDetails

Then pass entityCollection to output parameter

Was this reply helpful? Yes No