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!

CommentFileSizeAuthor
views-users.jpg63.18 KBweb506
views-comeout.jpg16.37 KBweb506

Comments

dawehner’s picture

Status: Active » Fixed

You have to use a view of type "user". You can select the type at admin/build/views/add

Status: Fixed » Closed (fixed)
Issue tags: -duplicate entry

Automatically closed -- issue fixed for 2 weeks with no activity.