HOWTO: Views 2 Relationships

Home
Submitted by drewish on Fri, 2008-12-19 12:48

After getting sick of closing issues in various module's issue queues that boiled down to people not knowing how to use Views 2's relationship feature I decided to make a screencast explaining it:

http://drewish.blip.tv/file/1593750/

I think I need to get a microphone, and figure out all the features of the tool I was using but I'm excited to do more of these.

Update: The GotDrupal folks have a much more detailed—and more understandable—screencast on this topic: http://gotdrupal.com/videos/drupal-views-relationships

Thanks - also a request

Submitted by juicytoo (not verified) on Tue, 2009-07-14 19:38.

thanks for this awesome screencast.

there was no way I would have got this reading some text.

A request, would you be able to do a screencast on creating og with rules and role promotions?

Should consider putting a paypal donate button on your site.

Thanks

This is of great help

Submitted by ipsita (not verified) on Thu, 2009-05-28 06:16.

The screencast is awesome. Now I completely understand Views relationship.

Thanks,

Thanks dude. I've watched

Submitted by Justin Hopkins (not verified) on Sun, 2009-05-10 15:46.

Thanks dude. I've watched this 3 times now. I keep coming back every time I can't seem to figure out what I'm doing with relationships. It really helps.

Great screencast!

Submitted by Don (not verified) on Mon, 2009-04-27 14:52.

Thank you for this awesome tutorial, it helped me to finally understand relationships in Views!
Do you maybe have plans to do another screencast for using arguments in Views? I've read a vast number of tutorials about it and understand the theory behind arguments but I have problems to use them properly on my page, e.g. displaying box-content related to the page the visitor is watching at the moment. I'm kinda stuck since weeks with it... sucks...
But anyway, thanks again for this screencast!

Great tutorial thanks!

Submitted by Joe (not verified) on Mon, 2009-04-27 13:08.

keep up the good work!

thanks

Submitted by sumitk (not verified) on Mon, 2009-03-30 21:12.

thanks!! for this awesome tutorials

now I understand relationships ;)

thanks!

Submitted by Evan (not verified) on Sun, 2009-03-08 01:12.

Really good tutorial. Best explanation I've seen yet for Views 2 Relationships. Thanks!!

In a typical gallery/images

Submitted by Anonymous (not verified) on Tue, 2009-01-27 17:11.

In a typical gallery/images situation you have one gallery and many images with nodereference to the parent gallery.

Can you use views relationships to show a list of galleries and along with each gallery title show the first image that references it? This is basically your example in reverse: show a list of companies together with the first (random) department in each company?

Thanks for the help!

yeah it sort of breaks down

Submitted by drewish on Sun, 2009-02-15 16:29.

yeah it sort of breaks down right there because the relationships aren't bidirectional. the best workaround for that type of a use case is to add a nodereference to the album node for the "high light" image. you can use a view to restrict the allowed values to only nodes referencing the album. i think you'll find that users like the flexibility of choosing the highlight image.

thanks for information.

Submitted by betsson (not verified) on Mon, 2009-07-20 03:40.

thanks for information.

Exactly the question I

Submitted by jwaxman (not verified) on Sun, 2009-02-01 14:23.

Exactly the question I had.
If the node type being "filtered in" is the container object, how do you get at the containees that reference it?

Eye opener

Submitted by yaph (not verified) on Thu, 2009-01-22 15:55.

Thanks a lot for this video tutorial. Watching it helped me understand how to use Views relationships and that they are an übercool feature.

thanks for information.

Submitted by betsson (not verified) on Wed, 2009-04-15 04:25.

thanks for information.

This is great! Thanks for

Submitted by jdann (not verified) on Wed, 2009-01-21 15:04.

This is great! Thanks for putting in the effort. If you do more of them, I will be happy to watch and learn :).

displaying file title as link text instead of filename

Submitted by hmlarson (not verified) on Thu, 2009-01-15 15:04.

Thank you for posting this great video. I'm trying to change how a filefield is displayed using Views2. Rather than displaying as "file.pdf", I would like the link to be the file title. I have the following set up using CCK and Views 2:

Content Type: Form
Fields:
Form Name (text)
File Description (text)
Form File (filefield)

I've setup a relationship for the Form File in Views 2 and set up everything similar to your video - but am not getting the Relationship drop down that displays to connect it with the Form Name (I've also tried this with Node Title - but am still not seeing the dropdown). Any tips?

Really great video

Submitted by Drupal Themes Garden (not verified) on Mon, 2008-12-22 07:13.

Really great video tutorial.
Thanks.

Thanks for the video -- so

Submitted by MasterJ__ (not verified) on Sun, 2008-12-21 01:45.

Thanks for the video -- so using node reference and views 2 relationships, I should theoretically be able to do a reverse node reference lookup?

For instance, I'm creating a new image node and choose to connect it via node reference to a node type called project. Project doesn't know anything about the image nodes that are "node referenced" to it...

so somehow I create a relationship...

and this is where I get confused... In a database world, I simply create a many to many relationship and run a query to pull related nodes from either end. I want my project node to know about my pictures nodes... it seems like a simple idea, really.

Anyway, again thanks for the video, it helped me understand this part of views 2. Please make more...

- MJ

yes, you should

Submitted by drewish on Mon, 2008-12-22 02:26.

it sounds like rather than a relationship, that you'd want to use an argument on the node reference field. then you could get a list of the images that reference the project and display them in a block on the project (or something like that).

Excellent

Submitted by Dale (not verified) on Sat, 2008-12-20 14:11.

Thanks for the well thought out example! As with Ryan, you've allowed me to check a piece of research off my to-do list.

Views relationships + Rules can replace modules in D6

Submitted by nonsie (not verified) on Sat, 2008-12-20 12:08.

I was just playing with a combination of Rules module and Views to create a system to notify content authors of the comments posted on their content with a link to a view showing their content, comments and optionally comments on similar content. No need to install an additional module to get comments on your content;)

Awesome screencast!

Simply astounding. Thanks

Submitted by flevour (not verified) on Sat, 2008-12-20 09:54.

Simply astounding. Thanks for taking the time to record this and kudos to Views 2 developers for creating such an amazing tool!!!

Thanks this was awesome

Submitted by Joe Moraca (not verified) on Sat, 2008-12-20 07:56.

Thanks for taking the time to do this. Now I understand how views relationships work!!! Views 2 is so awesome but has so little user documentation. Videos like this just make it so much better.

Was just playing around with

Submitted by Ryan (not verified) on Fri, 2008-12-19 16:18.

Was just playing around with Views 2 / OG last night and remember thinking, "huh... I wonder what relationship are." Thanks for the timely screencast!

And yeah, a mic might be good. ^_^

understand how

Submitted by canli iddaa (not verified) on Sun, 2009-05-24 18:42.

Now I understand how vieews relationshipss work.. Views 2. is so awesome but has so little user documentation. Videos like this just make it so much better.