By Z2222 on

I have three content types: program, course description, and course instance. They have node relationships, so the course instances have a node relationship field to course description, which have a relationship to program. In my view of course instances, how do I show the program?

Here is an illustration:
http://i.imgur.com/7ZIrY.png

I tried adding a view relationship to program, but get: "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'field_data_field_program.nid' in 'on clause'"

Edit: here are some more screenshots:
http://imgur.com/a/fTPWH
http://i.imgur.com/4xnMi.png

I don't know if the node relationships are correct.

Here is a link to the view:
http://bit.ly/w0TN2O

⋅ Categories: Drupal 7.x

Comments

pelicani’s picture

pelicani commented

I'm getting the same thing on one our sites as well.
If I alter the table column name to nid, the query runs as expected.
But the node relationship doesn't work in the node edit page.
Which I expected.

How come the column naming isn't working for a view relationship in dv7?
The sql is not getting constructed correctly, eh.

I'll be looking into it, but if there is a suggestion available, I'm game.

Technical Architect : Philadelphia, PA