OrderBy multiple properties in Razor and Umbraco 4.11.8

Question

During an update of our website with Umbraco, we upgraded from 4.7.2 to 4.11.8.

In a CSHTML-File I had this code:

foreach(var item in Model.AncestorOrSelf("Master")
                         .Items.First()
                         .PublicationFolder.First()
                         .Children.Where("Visible")
                         .OrderBy("publicationType, date desc"))

It worked fine and sorted the collection first by publicationType and then by the newest date.

In the new version (4.11.8) it doesn't work anymore. It gives me an exception: At least one object must implement IComparable.

And if I write .OrderBy("publicationType", "date desc"), it doesn't affect the collection.

So is this a bug or am I doing anything wrong? Is there a workaround?

Answer 1

I found a solution so I need to cast the collection to a List<DynamicNode> so that it works.

foreach (var item in ((List<DynamicNode>)@Model.AncestorOrSelf("Master")
    .Items.First()
    .PublicationFolder.First()
    .Children.Where("Visible").Items)
    .OrderBy(t => t.GetPropertyValue("publicationType"))
    .ThenByDescending(t => t.GetPropertyValue("date")))

Answer 2

The Where("Visible") extension returns IQueryable<DynamicNode> so you should be able to apply the LINQ OrderBy() and OrderByDescending() syntax for this query. You may need to alter certain bits though:

foreach(var item in Model.AncestorOrSelf("Master")
                     .Items.First()
                     .PublicationFolder.First()
                     .Children.Where("Visible")
                     .Cast<DynamicNode> // This line is optional
                     .OrderBy(x => x.GetPropertyValue("publicationType")
                     .ThenByDescending(x => x.GetPropertyValue("date"))

I have included an optional line to show that you can explicitly cast the dynamic objects to DynamicNode objects and you can then use intellisense in your view.

Answer 3

If memory serves you should be able to chain the OrderBys

foreach(var item in Model.AncestorOrSelf("Master").Items.First().PublicationFolder.First().Children.Where("Visible").OrderBy("publicationType").OrderByDescending("date"))