Dynamics CRM OrderBy expression not working

Question

I am trying to download Lead IDs from Dynamics CRM and I need them ordered by the LeadId :

    IOrganizationService orgService = dynamicService.OrgService;
    QueryExpression request = new QueryExpression()
    {
        EntityName = "lead",
        ColumnSet = new ColumnSet("leadid"),
        Criteria = new FilterExpression(),
        PageInfo = new PagingInfo() { ReturnTotalRecordCount = true, Count = 50, PageNumber = 1 }
    };
    request.Orders.Add(new OrderExpression("leadid", OrderType.Ascending));

    EntityCollection response = orgService.RetrieveMultiple(request);
    foreach(Entity e in response.Entities)
    {
        Console.WriteLine($"{e.Attributes["leadid"]}");
    }

However, this is returning them in random order.

b9b0f003-356d-e911-a966-000d3a1d7430
4298cdf4-4370-e911-a966-000d3a1d7430
97582b3c-2f6d-e911-a971-000d3a1d7b43
92d57a83-338f-e611-80e0-c4346bb588e8
a0d57a83-338f-e611-80e0-c4346bb588e8
a2d57a83-338f-e611-80e0-c4346bb588e8
a6d57a83-338f-e611-80e0-c4346bb588e8

What am I doing wrong here?

https://stackoverflow.com/questions/46595370/c-sharp-mscrm-sdk-queryexpression-default-order/46596239#46596239 — Aron, May 24 '19 at 18:25
True - But you can see that I am specifying that I want it ordered by"leadId" with an OrderExpression — AcidPAT, May 24 '19 at 20:57
I think Arun answered your question. You could take the results, convert the guid to a string, and sort on that value. — Zach Mast, May 25 '19 at 13:51

score 2 · Accepted Answer · answered May 25 '19 at 02:51

This is correctly sorted per GUID sort algorithm.

The comparison is made by looking at byte "groups" right-to-left, and left-to-right within a byte "group". A byte group is what is delimited by the '-' character. More technically, we look at bytes {10 to 15} first, then {8-9}, then {6-7}, then {4-5}, and lastly {0 to 3}.

So b9b0f003-356d-e911-a966-000d3a1d7430 is smaller than 4298cdf4-4370-e911-a966-000d3a1d7430.

Similarly 4298cdf4-4370-e911-a966-000d3a1d7430 is smaller than 97582b3c-2f6d-e911-a971-000d3a1d7b43.

And so on.

Dynamics CRM OrderBy expression not working

1 Answers1