Hello everyone,

My question is in regards to my current installation of Drupal 4.7.4, views.module, cck package (specifically the node reference module) and the viewfield.module

My objective is to create a small movie database that lists movies and crew as separate node types and to have each type be referenced within each other. For example, A 'movie' will list the crew when viewing a movie node. You can click on any of the crew and you will be directed to a 'crew' node type where all of the movies this person has been a part of will be displayed and referenced.

I'd like to do this with CCK and views as they can be customised to exactly what I require. I did stumble upon the 'Movie Database' module however, it did not suit my needs.

I currently have two cck node types (for simplicity of describing the issue, I have used the names):
1. 'movie'
2. 'crew'

The fields in 'crew' are:
'name' (textfield)
'bio' (textfield)
'credits' (viewfield)

The fileds in 'movie' are:
'title' (textfield)
'year' (textfield)
'director' (nodereference > crew)
'producer' (nodereference > crew)
'editor' (nodereference > crew)
etc...

I'm at what I believe to be the last step of the process in which I am to create a views query that will be embedded in the 'credits' (viewfield) in each of the 'crew' nodes, in order to display the movies that the 'crew' has been a part of. Either as a director, producer, etc...

So my question is what is the best way to do this, and how?

Do I either

1. Create a separate views query for each 'crew' node that is customized to their title field ('name' (textfield))?
or
2. Create 1 view that has an argument (of some sort?) that will filter all movie nodes that the current crew node has worked on and their job title on that film (director, producer, etc.).

I would assume 2. would be a more elegant way of doing this, but I am really stuck when it comes to the arguments portion of the views.module.

I have done some research in the handbook, but I can't seem to make sense of what it says and apply it to what I am trying to accomplish.
If anyone has any input on this issue or any questions, please post it here and I will be more than grateful for your insight.

Thanks in advance,
txcrew

Comments

Super Druper’s picture

Your question resonates exactly with a similar challenge I am facing at the moment. This is very much the same setup I am trying to implement, however, for a different purpose. From what I could see on your website (great site, might I add), you've put it together successfully . What approach did you take to sort this out? I would greatly appreciate it if you could point me in the right direction and more so if you could expand on how you implemented this. Thanks in advance.

Anonymous’s picture

Hey there Super Druper,

Things have changed since then and I no longer use the view-field to make this happen. Just several views with cck noderef field. Its acutally quite simply explained over at this thread http://drupal.org/node/161867

Hope this helps!

txcrew

--------
http://3to1studios.com