How to implement view with nodes grouped per taxonomy term

Question

I have a content type 'Event' which has a 'Category' content taxonomy field (single selection against respective 'Category' vocabulary). If vocabulary has 3 terms, I want to implement a listing where all 3 terms will always be displayed, along with the newest event for each category (sort by publication date in descending order). Something like this:

Category 1

Title of newest event for category 1

Category 2

Title of newest event for category 2

Category 3

Title of newest event for category 3

What is the best way to implement this with views in Drupal 6?

Answer 1

You must use the group option in the style display. In group option you must select the field taxonomy term. And then you must Exclude from display the field taxonomy term.

Answer 2

Desired solution implemented using the Views Grouping Row Limit module. Here is a quote about it (from the module's project page):

This is a basic Views style plugin that allows for a limit on the number of rows displayed within a grouping field ...

To use this module, simply change the style plugin for your view to the "Grouping Field (with Limit)" option. You will then be presented with options to choose your limit and offset (the offset just controls what row to start on, e.g. an offset of 1 would omit the first row from each grouping field). Please note that in order for this to take effect, you must set your row limit on the actual view to Unlimited.

Answer 3

https://drupal.org/project/views_field_view might be the solution to your issue. Granted it must be used with caution as it adds some extra overhead but ultimately it grants the SELECT FROM SELECT query that solves your problem.