Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
By bkark on
I was hoping someone could give me advice on how to configure Views to do the following, if it's even possible:
I created a new content type, Video, that displays embedded YouTube videos of concerts. Each node will display one video from a single band. I'd like to create a block that displays the most recently added videos. That's easy enough to do but what's stumping me is that I want to further filter the view so that it only shows one video per band in the block.
For example, say I have four videos of four separate bands and my block is set to display 5 nodes. With my current setup, it works perfectly. All four videos are displayed in descending order based on when they were added to the site. Now if I add a fifth video, but this time the video is of one of the bands that I've already added, it should knock out the older video of that band and so the block should still display four nodes instead of five.
Right now the view is setup to filter on "Node:Type" of "Video" and sort on "Node: Created Time". The "Video" content type consists of a "Node Reference" to a "Band" content type among other fields.
My only solution so far would be to add a checkbox field to "Video" that would signify if the video is the latest video from that band. Then in my view I could filter on that field in addition to the node type and sort on creation date. It's not a great solution but it should work if I can't find a more elegant one.
Thanks!
-Brian
