Oke, I have a problem building a view using Node-reference and Voting API.
I will explain.
I have two content types; 'Album' and 'Album-review'
Album has cck files like singer, genre, date of release. etc.
Album-review has a node-reference view to 'Album' and a lot off 'fivestar rating' cck fields. Think of thes fiels as 'quality of singer', 'quality of the band' 'quality of recording', 'quality of booklet'
This way all visitors of my site can post a Album-review. Nice, drupal Rocks!!

Oke, now I want to build a view;

I want an overview of all 'Albums', on one axis, and the Average fivestar rating of all 'Album-review' cck fields on the other.

After a few days of trying I am close, but I have no cigar yet.

Setting up the Filter as Node-type 'Album-review' I get all the filed I want, but I can't get an average of the five-star rating, it displays al individual 'Album-reviews'

Setting up the filter as node-type 'Album' I can't get the review fileds to display. I have set the relation to 'Album-review' as required.

Can someone shine a little light on this issue please??

p.s. I will cross-post this in the views issue as well..

CommentFileSizeAuthor
#2 Selectah-UML.png18.98 KBAnonymous (not verified)
#2 selectah.png18.05 KBAnonymous (not verified)

Comments

gunzip’s picture

gunzip commented

have you added a "voting results" relationship with AVG aggregation ?

Anonymous’s picture

Anonymous (not verified) commented
StatusFileSize
new selectah.png18.05 KB
new Selectah-UML.png18.98 KB

I have indeed.

I have been struggling a lot, nd still don't have the solution.

I have uploaded two images with this post. Can someone enlighten me??

Thanks...

gunzip’s picture

gunzip commented

i have a similar problem. i have reviews and articles and i want to show average votes on articles casted trough reviews.

this goes wrong even if a add a relationship in my view.

the sql join is always executed against node.nid (which is the __review__ table in this context) instead of content_type_article.

it seems that votingapi + view relationship is broken somehow.

Anonymous’s picture

Anonymous (not verified) commented

Checkt this tutorial:
http://drupal.org/node/457886

Works for me!!

gunzip’s picture

gunzip commented

the tutorials is ok but the fact is that the relationship "broke" when you have a nodereference field in the content type and you're trying to display the votes for the __other__ content type through this relationship.

j_ten_man’s picture

j_ten_man commented

I can confirm this bug. Node-references are not supported by the Voting API Views integration. This is a major limitation and hopefully it will be fixed in the next release. Also, it looks like this issue was duplicated: http://drupal.org/node/480036

Both issues sound to be the same.

My scenario is as follows:
I have courses and course registrations. Users can rate the course. Then, I am trying to create a view that shows each user's registration and then the rating they gave to the course. A course registration has a node reference to the course, but when I create the view the votes are being joined to the course registrations content type and not the courses content type even though I have created a correct relationship. This is a bug because a user rates a course and enters a comment at the same time. I am able to pull the comment in to the view and it is correct, but the rating is not.

gunzip’s picture

gunzip commented

it's still me that've opened that issue as this one was initially an unrelated support request =)

eaton’s picture

eaton commented
Status: Active » Closed (duplicate)

#480036: cannot get vote values through nodereference relationship is fixed, thanks for the catch on the relationship issue, j_ten_man!