Hi All,
I am having issues with Views, it is showing multiple repeated items.
This is the generated query:
SELECT DISTINCT(node.nid) AS nid, users.uid AS users_uid, users.picture AS users_picture, users.name AS users_name, users.mail AS users_mail, node.language AS node_language, node.nid AS node_nid FROM node node LEFT JOIN users_roles users_roles_value_0 ON node.uid = users_roles_value_0.uid AND users_roles_value_0.rid = 5 INNER JOIN users users ON node.uid = users.uid WHERE users_roles_value_0.rid = 5 GROUP BY nid ORDER BY node_nid ASC
You can also find the Views Configuration and the comeout in the attached images.
I noticed that for some reason it is creating multiple items due to a node ID, I am using the core profile module but I am not even calling any of the profile fields, only User ID, User Image and the Node ID because while I was troubleshooting I found that and I think it could relate to the problem I am having.
I will really apppreciate your help, please advise me on this one, thanks!
| Comment | File | Size | Author |
|---|---|---|---|
| views-users.jpg | 63.18 KB | web506 | |
| views-comeout.jpg | 16.37 KB | web506 |
Comments
Comment #1
dawehnerYou have to use a view of type "user". You can select the type at admin/build/views/add