Drupal View display - setting a limit for the query results

Posted by EricP on Stack Overflow See other posts from Stack Overflow or by EricP
Published on 2010-04-02T13:49:21Z Indexed on 2010/04/02 13:53 UTC
Read the original article Hit count: 422

Filed under:

drupal

|

drupal-views

|

limit

I have a View set to grab the latest forum posts. That's working fine, but I'd like to limit it to get the last 5 records only. I know I can display only 5 with PHP but I don't want a larger query than I need. I can't find any option for this in the View.

thanks

© Stack Overflow or respective owner

Related posts about drupal

Commercial Drupal Modules & Themes

as seen on Just Skins - Search for 'Just Skins'
A discussion at Drupal.org forums prompted me to give my input about commercial ecosystem around Open Source Content Management Systems. WordPress and Joomla have been growing rapidly since past few years. But, growth rate of Drupal seems to be almost flat. Despite being the most powerful CMS around… >>> More
better to wait Drupal 7 to start learning Drupal, or no big difference with Drupal 6?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi friends, I'm going to start some projects in next weeks. I currently have my custom cms, but i wanna go for opensource cms solution from now on. and as i researched Drupal is COOL for any kind of project from small scope to most complex ones. I have never used Drupal before, I know nothing about… >>> More
Drupal 6: Drupal Themer gives same candidate name for different type of content types

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi friends, I'm a drupal newbie... I have different type of contents like News, Events, etc. and their content is different. News detail page has title-content text-date. but Events detail page has title-date-content text-location-speaker-etc. So I need different layout page for these different… >>> More
drupal: how to generate doc files in drupal is there any possibility to that

as seen on Stack Overflow - Search for 'Stack Overflow'
how to generate doc file in drupal files.. do we have module for that... as pdf generation module... >>> More
Drupal 6 vs Drupal 7 performance

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all. I want to start new project and stuck without idea what version to use. I have huge expirience with D6, and also one project (module developement) for D7. It looks like D7 slower, have bigger memory consumption and also have a lack of documentation by the moment. I don't need new CCK, Views… >>> More

Related posts about drupal-views

Drupal, Views, Exposed filter, make tags unselectable

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, I'm using Drupal Views with an exposed filter with several tags. I would like to make some tags "unselectable", if they cannot be combined with the already selected tags. (They would give empty results page. thanks >>> More
Drupal: Views, exposed filter settings: show customer only initial selection option

as seen on Stack Overflow - Search for 'Stack Overflow'
hi, I'm using Views, exposed filter. I would like to allow my user to select the initial items, without giving him access to all views functionalities and filter functionalities... is that possible ? How can I just show him the initial terms selection from Views settings ? thanks >>> More
Drupal: Views: exposed Taxonomy filter: additional functionalities

as seen on Stack Overflow - Search for 'Stack Overflow'
hi! I'm using Drupal Views with an exposed filter (improved with better exposed filters module) based on taxonomy. I have a list of nodes and for each node I assigned several tags. I would like to add the following functionalities to the filter: 1 - when few tags are selected, I would like to disable… >>> More
Drupal Views Duplicate values being returned when using a relationship

as seen on Stack Overflow - Search for 'Stack Overflow'
I am having a problem with views. I have a view and am passing it a taxonomy term by name to it. I then have a relationship to a related node. For my output fields I am returning the related Title and related Body. I however have duplicates in my results. I have turned distinct to yes but believe… >>> More
Drupal Views Multiple values being returned when using a relationship

as seen on Stack Overflow - Search for 'Stack Overflow'
I am having a problem with views. I have a view and am passing it a taxonomy term by name to it. I then have a relationship to a related node. For my output fields I am returning the related Title and related Body. I however have duplicates in my results. I have turned distinct to yes but believe… >>> More