CODEWITHSUNDEEP
c#listrazorsql-order-byumbraco
Goran Hrustić
Goran Hrustić

Reputation: 81

Sort child nodes by date - Razor Umbraco

For the following examples, I'm using a content tree which looks like this: Content tree

@inherits Umbraco.Web.Mvc.UmbracoTemplatePage
@{
    var home = Model.Content.Descendants().Where(x => x.DocumentTypeAlias == "BlogContainer");

    <div class="container">
        <ul>
            @foreach (var item in home)
            {
                foreach (var items in item.Children)
                {
                    foreach (var baby in items.Children.OrderBy("date desc"))
                    {
                        var date = baby.GetPropertyValue<DateTime>("date");

                        <li>@items.Name - @baby.Name - @date</li>
                    }
                }
            }
        </ul>
    </div>
}

And the result is Result three I need to collect all items and set order by date

Upvotes: 1

Views: 4311

Answers (2)

denford mutseriwa
denford mutseriwa

Reputation: 548

Try and do something like 

var allItems = homePage.Descendants("YourItemNodeType")
            .Where(item => item.HasValue("date")
                              && item.GetPropertyValue<DateTime>
                                  ("date") != DateTime.MinValue)
            .ToList()
            .OrderByDescending(item => item.GetPropertyValue<DateTime>("date"));

This should get you all your items in both category 1 and category 2, i always tend to check if my date is actually set ( you wouldnt need to do that for create date mentioned by @bowserm as that is always there with a value).

Once u got them to List then you can sort them by their set date, i do this on when i list news articles in different parent pages, then you can just have one loop to go through all of them.

Upvotes: 3

bowserm
bowserm

Reputation: 1056

First of all, what Umbraco version are you using? It looks like you are using 6+? Is that right? My answer below should work for 6 and 7.

The property you are looking for is called createDate, so you would use something like baby.GetPropertyValue<DateTime>("createDate"). Even better, you should be able to just type baby.CreateDate. Umbraco has exposed all of the default properties that you might want on the IPublishedContent as properties, so you can get at those without having to use GetPropretyValue(...).

Take a look at this Umbraco v6 MVC Razor Cheatsheet. It lists the default properties you can get off of the nodes in Umbraco. The razor syntax for v6 will also be applicable to v7, so this cheat sheet works for both.

Upvotes: 0

Related Questions