By knowing_prophet on

On one of my company's sites the newest node is displayed at the top of the page, and then further down the page the next 3 most recent nodes should be displayed. Out of those 3 I don't want one to be the most recent node which has already been displayed, so I'm looking for a way to "exclude" the first result from a View.

This is easy using PHP, utilizing MySQL's LIMIT command (LIMIT 1, 3 would skip the first result and list the next 3), but I can't find a way to do this with Views. Though it wouldn't be used a whole lot, if Views cannot currently do this I definitely think it is worth adding the functionality, if someone knows how to do so. It would open up possibilities for more advanced sorting/limiting.

If you know how to create this feature in Views and can take the time, please do. Or if it really is already possible, please let me know how.

⋅ Categories: Drupal 4.7.x

Comments

xrintrahx’s picture

xrintrahx commented

I just installed views and couldn't figure out of this was possible. Has anyone found a way to exclude the most recent item from a list? If not, is there a way to do this with PHP?

mlncn’s picture

mlncn commented

If someone already knows, that would be very handy.

~ben

People Who Give a Damn :: http://pwgd.org/ :: Building the infrastructure of a network for everyone
Agaric Design Collective :: http://AgaricDesign.com/ :: Open Source Web Development

benjamin, Agaric