ExpressionEngine® Answers is a question and answer site for administrators, end users, developers and designers for ExpressionEngine® CMS. It only takes a minute to sign up.
Sign up to join this community
Noob question, but trying to get all channels to show single entry by latest date on the homepage of the site. User guide says leave blank and will default to all, but no luck. I have 71 channels and doing all of them would be a real bear.
thanks in advance.
Like Michael said, 71 channels seems like alot! sounds like you wanted to categorise similar entries instead of seperating by channel! However...
Ours is not to reason why, ours is but to do and die
SO, here's your solution. I use SQL to draw the 'Maxed' entries out of the DB (grouped by channel), from this I can then populate a single exp:channel@entries loop. We need to use some PHP on the template, and it needs to be on input so we can use it to populate our entries tag :
<?php
//get the entry_ids for the max entry date, by channel
$res = ee()->db->query('
SELECT entry_id
FROM (
SELECT *
FROM exp_channel_titles
ORDER BY entry_date DESC
) AS a
GROUP BY channel_id
ORDER BY channel_id ASC
');
//concatenate the results into a string
$eids = "";
if ( $res->num_rows() > 0 ) {
$eids = implode("|",$res->result_array());
} else {
//break the string of entry id's if we have no results
$eids = "XX";
}
?>
{exp:channel:entries dynamic="no" fixed_order="<?php echo $eids; ?>"}
<h1>{title}<sup>{channel}</sup></h1>
<a href="{url_title_path='group/template'}">permalink</a>
{/exp:channel:entries}
PHP ON on Input
Have fun!
references
