Forum posts to 'Site Builders'

Re: Displaying first 5 news items from multiple years

Bruce Bowden — Thu, 15 May 2008 12:17:01 +1200

Looking at that code, it would seem to pull 5 news items from each year, rather than 5 in total. I have attacked it from a different point, creating a new page type called NewsPage, which is just a duplicate of ArticlePage. Now I can pull the most recent media releases, where ever they are, using:
function LimitedNews($limit) {
$littlechildren = DataObject::get("NewsPage", "", "Date DESC", null, $limit);
return $littlechildren;
}

cheers
bruce

Posted to: Displaying first 5 news items from multiple years

Re: Displaying first 5 news items from multiple years

Will Rossiter — Wed, 14 May 2008 23:36:20 +1200

So you have 1 article holder for each year?? Then you can get a DataObjectSet of every ArticleHolder then query on each to return the children - or pages with that parent ID as we need to limit it to 5. Remember this is cut down to make it easier to read. I would add an if round the foreach to prevent any errors and you might want to get the ArticleHolders in some order.

$output = new DataObjectSet();
$years = DataObject::get("ArticleHolder");
foreach($years as $year) {
$articles = DataObject::get("ArticlePage","ParentID = $year->ID","","", 5);
$output->push($articles);
}
return $output;

Posted to: Displaying first 5 news items from multiple years

Displaying first 5 news items from multiple years

Bruce Bowden — Wed, 14 May 2008 19:42:42 +1200

The Tutorial has an example that shows the last 5 news items on the front page. However I have grouped my media releases under ArticleHolder pages by year so I can't just use "ParentID = $this->ID" as the filter in the DataObject::get.

I need to say: "Find all the ArticlePages that have the 'Media releases' page at Level(2)".

Does someone have the appropriate syntax for that? Or do I need to provide more context?

cheers
bruce

Posted to: Displaying first 5 news items from multiple years