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
Comment #1
drtrueblue commentedI was advised this was an issue with views, so I have opened an issue in the views queue.