when set to "Group results together" the field is not collapsed and multiple nodes are list. The groups by querry is never even entered:

SELECT DISTINCT(node.nid) AS nid_1,
node.nid AS nid,
profile_values_profile_grade.value AS profile_values_profile_grade_value,
profile_values_profile_prefix.value AS profile_values_profile_prefix_value,
profile_values_profile_last_name.value AS profile_values_profile_last_name_value,
profile_values_profile_last_name.uid AS profile_values_profile_last_name_uid,
node.title AS node_title,
node_revisions.teaser AS node_revisions_teaser,
node_revisions.format AS node_revisions_format,
node.created AS node_created,
users.name AS users_name,
users.uid AS users_uid
 FROM node node 
 INNER JOIN users users ON node.uid = users.uid
 LEFT JOIN profile_values profile_values_profile_grade ON users.uid = profile_values_profile_grade.uid AND profile_values_profile_grade.fid = '6'
 LEFT JOIN profile_values profile_values_profile_prefix ON users.uid = profile_values_profile_prefix.uid AND profile_values_profile_prefix.fid = '3'
 LEFT JOIN profile_values profile_values_profile_last_name ON users.uid = profile_values_profile_last_name.uid AND profile_values_profile_last_name.fid = '2'
 LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
 WHERE (node.status = 1 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (node.type in ('blog_multi_user'))
   ORDER BY profile_values_profile_grade_value ASC

When "count" or sum or anything is used it does not count or sum. It just has 1 and the nodes are not collapsed to one entry.

SELECT DISTINCT(node.nid) AS nid_1,
node.nid AS nid,
COUNT(profile_values_profile_grade.value) AS profile_values_profile_grade_value,
profile_values_profile_prefix.value AS profile_values_profile_prefix_value,
profile_values_profile_last_name.value AS profile_values_profile_last_name_value,
profile_values_profile_last_name.uid AS profile_values_profile_last_name_uid,
node.title AS node_title,
node_revisions.teaser AS node_revisions_teaser,
node_revisions.format AS node_revisions_format,
node.created AS node_created,
users.name AS users_name,
users.uid AS users_uid,
profile_values_profile_grade.value AS profile_values_profile_grade_value_1
 FROM node node 
 INNER JOIN users users ON node.uid = users.uid
 LEFT JOIN profile_values profile_values_profile_grade ON users.uid = profile_values_profile_grade.uid AND profile_values_profile_grade.fid = '6'
 LEFT JOIN profile_values profile_values_profile_prefix ON users.uid = profile_values_profile_prefix.uid AND profile_values_profile_prefix.fid = '3'
 LEFT JOIN profile_values profile_values_profile_last_name ON users.uid = profile_values_profile_last_name.uid AND profile_values_profile_last_name.fid = '2'
 LEFT JOIN node_revisions node_revisions ON node.vid = node_revisions.vid
 WHERE (node.status = 1 OR (node.uid = ***CURRENT_USER*** AND ***CURRENT_USER*** <> 0) OR ***ADMINISTER_NODES*** = 1) AND (node.type in ('blog_multi_user'))
 GROUP BY nid_1
  ORDER BY profile_values_profile_grade_value_1 ASC

Comments

MustangGB’s picture

Status: Active » Closed (won't fix)