Unable to join two content types by node reference
| Project: | Views Fusion |
| Version: | 5.x-1.2 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Maybe I'm misunderstanding the purpose of this module, but this description sounds very close to my objective. I'm using Drupal 5.2 with Views 5.x-1.6 and Node Family 5.x-1.3.
Essentially, I am trying to join two content types by a node reference, but instead of a 1 to many join, this is producing a list of ALL the possible combinations (many to many). The node types are "Class" and "Class Timeslot". Each "Class Timeslot" has a CCK Node Reference field pointing at the Class content type.
Here is what I did;
1. I created a node family relation with Parent Type="Class" and Child Type="Class Timeslot".
2. I created a view of the "Class" content type and a view of the "Class Timeslot" content type.
3. I fused the views using the "Class" view as the primary view using the "nodefamily relation: parent - child".
The result is a list connecting every "Class Timeslot" to every "Class", instead of using the node reference value in "Class timeslot" to eliminate irrelevant relationships. There are some filters which may be interfering, but this is the crux of the problem that I am having right now.
Am I missing something? Is this something that Views Fusion was designed for?

#1
Mystery solved! Apparently, I hadn't properly applied the nodereference patch. This took me a while to figure out because the documentation does not explain that the join should be created with the nodereference options that appear in the "Using" dropdown as depicted in the attached screenshot.