Drupal 7 / Views 7.x-3.0-alpha1
I want to list a user's comments. The user is given by the url. The problem is that it shows me comments from other users.
Here's my setup and views Query:
http://i52.tinypic.com/2rrrnnp.jpg
SELECT node_comment.title AS node_comment_title, node_comment.nid AS node_comment_nid, node_comment__comment.subject AS node_comment__comment_subject, node_comment__comment.cid AS node_comment__comment_cid, node_comment__comment.nid AS node_comment__comment_nid
FROM
{comment} comment
INNER JOIN {users} users_comment ON comment.uid = users_comment.uid
INNER JOIN {node} node_comment ON comment.nid = node_comment.nid
LEFT JOIN {comment} node_comment__comment ON node_comment.nid = node_comment__comment.nid
WHERE (( (users_comment.uid = '1') ))
LIMIT 10 OFFSET 0
This is the view:
/* Display: Página */
$handler = $view->new_display('page', 'Página', 'page_1');
$handler->display->display_options['defaults']['relationships'] = FALSE;
/* Relationship: Comentario: Usuario */
$handler->display->display_options['relationships']['uid']['id'] = 'uid';
$handler->display->display_options['relationships']['uid']['table'] = 'comment';
$handler->display->display_options['relationships']['uid']['field'] = 'uid';
$handler->display->display_options['relationships']['uid']['required'] = 1;
/* Relationship: Comentario: Nodo */