I need something very much like this where I can access the last three items (or whatever arbitrary number) on the home page of the site. So on the blog there are these four entries:

1. My dog caught a ball. May 17, 2016
2. My cat caught a mouse. May 15, 2016
3. The rat was bothering the cat. May 14, 2016
4. The trees were green. May 12, 2015

On my home page I want to have the first three on my home page.

OK. More progress.

I found this code:

@{
    var blogRoot = Umbraco.ContentAtRoot().DescendantsOrSelf("Articulate").FirstOrDefault();
    var blogArchive = blogRoot.Children.First();

    foreach(var blogposts in blogArchive.Children.Where("Visible").Where("categories == @0","TestCategory")){
        <p>@blogposts.Name</p>
    }
}

And I added it to my home page and I now get the Name of each blog post in the archive listed on my home page. However I want the content of the post not the name.

Question:

1. What do I need to replace @blogposts.Name with to get the body of the blog post?

2. How can I get a list of the keys in blogspots so I can pick and choose what things in the post to display?

OK Yet more progress...

I finally found out how to get the key in the object by looking in the cmsContentXml table in the Umbraco.sdf.

In the XML column you can find the content and then use the tags there to get the names to put in blogposts.Name

To get the article content from the richText editor, you use blogposts.richText and they are then available on any page you need them with the following code.

@{
    var blogRoot = Umbraco.ContentAtRoot().DescendantsOrSelf("Articulate").FirstOrDefault();
    var blogArchive = blogRoot.Children.First();

    foreach(var blogposts in blogArchive.Children.Where("Visible").Where("categories == @0","TestCategory")){
        <p>@blogposts.richText</p>
    }
}

Hi Matt,

thanks for the input! I will try that.

Best Regards Andreas

Yes. You change the foreach Where("categories== @0","testCategory") to .Where("tags == @0","wolf")

Your code would look like this:

@inherits Umbraco.Web.Mvc.UmbracoTemplatePage
    @{
        Layout = "Master.cshtml";
    }
    @{
        var blogRoot = Umbraco.ContentAtRoot().DescendantsOrSelf("Articulate").FirstOrDefault();
        var blogArchive = blogRoot.Children.First();

        foreach(var blogposts in blogArchive.Children.Where("Visible").Where("tags == @0","wolf")){
            <p>@blogposts.richText</p>
        }
    }

    @CurrentPage.GetGridHtml("content", "fanoe")

COOL! Thank you. I am will update my code as well. This has been a good interaction. Thank you!

OK More questions. How do I limit the return to only two or three items?

Right now the blog items are coming into my page with the code above from Mark in the order of oldest to newest. How can I change that to newest to oldest.

My goal is to display only the most recent two blog entries in my page. I am successfully getting them all but in reverse order.

Currently:
My first blog entry - Monday, may 1
My second blog entry - Tuesday may 2
My third blog entry - Wednesday may 3
My fourth blog entry - Thursday may 4

I want (limit 2):
My fourth blog entry - Thursday may 4
My third blog entry - Wednesday may 3

I want (limit 3):
My fourth blog entry - Thursday may 4
My third blog entry - Wednesday may 3
My second blog entry - Tuesday may 2

is working on a reply...