By mtsanford on

Say I've got two CCK node types: Class and Student.

A Class node type has a node reference field that references Student nodes.

How can I create a view that shows all the Student nodes that are *not* referenced by any Class node?

Is this possible?

⋅ Categories: Drupal 6.x

Comments

ericpugh’s picture

ericpugh
he/him
Primary language English
commented

good question. I was going to say "relationships" in views2, but I'm not sure how you could get it to work backwards?
Maybe, you could write your own query. The node reference is saved as a nid in cck, right?

exobuzz’s picture

exobuzz commented

I have this same problem. If i could specify a default argument of "NULL" so that when views creates the SQL with left join it matched against NULL this would work, but views converts my NULL to a 0.