I have a few that is grabbing all published nodes from certain categories, and it works great. What I'm trying to do is limit the view so it *just* grabs the most recently published node from each of the selected categories. Is that possible?

A workaround I'm trying now is to manually make the most recent one sticky and use that. It works, but it leaves room for error.

Comments

merlinofchaos’s picture

merlinofchaos commented

Unfortunately, what you want to do is quite difficult with SQL, which means it's quite difficult to do with Views. The only way I can think to do that offhand is to create several views, each one printing just one node, and chain them together on a custom page.

chellman’s picture

chellman commented

Dang. Yeah, I hadn't looked at the tables to see how I'd do it with SQL, otherwise I might have known it was hard.

That was another possibility I had thought of. In that case, I'd be creating one view for each category and embedding them all on the main one. Is that right?

If I'm doing that, should the embedded views be provided as pages? I assume yes so they don't clutter up the blocks screen, but I wanted to check.

merlinofchaos’s picture

merlinofchaos commented

You can have them provide neither page nor blocks if you like, though there are some side effects to doing that. For what you're doing I don't think those side effects will matter but you'll have to try it and see.

If you're doing it just for categories, you can also make it just 1 view, use the category as an argument, and call the view multiple times.

chellman’s picture

chellman commented

Thanks, Merlin, I think I've done it. Check me on this approach, if you would.

$view = views_get_view('View_Name');

// array(1) is for taxonomy term 1, false means no pager, 1 means retrieve just one node
print "<h3>Latest Post From Category 1</h3>\n";
print views_build_view('embed', $view, array(1), false, 1);
print "<h3>Latest Post From Category 2</h3>\n";
print views_build_view('embed', $view, array(2), false, 1);
print "<h3>Latest Post From Category 3</h3>\n";
print views_build_view('embed', $view, array(3), false, 1);

If this is right, I'll probably post a comment on the relevant book page.

merlinofchaos’s picture

merlinofchaos commented
Status: Active » Fixed

Yes, that's pretty much in line with how I'd do it.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)