Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
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
Comment #1
MustangGB CreditAttribution: MustangGB commented