Forgive me if I'm missing something obvious, but I can't seem to create a views relationship from "Node: last comment author" to the corresponding content profile fields for that user. Otherwise, content profile is working just great and I'm able to set up all other relationships I need. I'm using Views 2 6.x-2.11, Content Profile 6.x-1.0, and Advanced Forum 6.x-1.1.

I don't seem to be able to get a good choice of fields in the relationship builder. I've played with all options I can think. Meanwhile, Node: last comment author is pulling that user information without any relationships or problems at all. Here is the Query Code that gets gets "Node: last comment author"

SELECT node.nid AS nid,
   node.title AS node_title,
   node.language AS node_language,
   COALESCE(ncs_users.name, node_comment_statistics.last_comment_name) AS node_comment_statistics_last_comment_name,
   ncs_users.name AS ncs_users_name,
   node_comment_statistics.last_comment_uid AS node_comment_statistics_last_comment_uid
 FROM node node 
 INNER JOIN node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid
 LEFT JOIN users ncs_users ON node_comment_statistics.last_comment_uid = ncs_users.uid AND ncs_users.uid != '0'
 WHERE node.type in ('di') 

So, is it possible to relate the content profile fields for the last comment author?
Any help would be greatly appreciated.

Comments

drtrueblue’s picture

Status: Active » Closed (works as designed)

I was advised this was an issue with views, so I have opened an issue in the views queue.