I have a problem with grouping my items with the 'Views Group By' module.
After testing the SQL query directly in my SQL database I learned that if I excluded some of the SQL query I ended up with the result that I needed.
It turnes out that the cause of my problem relates back to my 'language' module (my site is displayed in Danish). When I look at the SQL query I see that my system generates a node.language AS node_language
. When I omit this line in my query - then everything works fine.
SELECT COUNT(node.nid) AS nid,
term_data.name AS term_data_name,
term_data.vid AS term_data_vid,
term_data.tid AS term_data_tid,
node_data_field_image_w_link.field_image_w_link_fid AS node_data_field_image_w_link_field_image_w_link_fid,
node_data_field_image_w_link.field_image_w_link_list AS node_data_field_image_w_link_field_image_w_link_list,
node_data_field_image_w_link.field_image_w_link_data AS node_data_field_image_w_link_field_image_w_link_data,
node.language AS node_language,
node.type AS node_type,
node.vid AS node_vid
FROM node node
LEFT JOIN term_node term_node ON node.vid = term_node.vid
LEFT JOIN term_data term_data ON term_node.tid = term_data.tid
LEFT JOIN content_field_image_w_link node_data_field_image_w_link ON node.vid = node_data_field_image_w_link.vid
WHERE node.type in ('imagegallery')
GROUP BY term_data_name,
term_data_vid,
term_data_tid,
node_data_field_image_w_link_field_image_w_link_fid, node_data_field_image_w_link_field_image_w_link_list,
node_data_field_image_w_link_field_image_w_link_data,
node_language,
node_type,
node_vid
ORDER BY term_data_name ASC
.
Is there a way in which I can rearrange the SQL query code to omit the node.language AS node_language
?
Regards,
Svend
Comments
Comment #1
STNyborg CreditAttribution: STNyborg commentedWould it be possible to hardcode a function in the views_groupby_handler_field_groupfields.inc file that removes the node.language line from the SQL query?
I know this is shortsighted and definitely not pretty coding, but I am running out of options...
Please help.
Svend
Comment #2
STNyborg CreditAttribution: STNyborg commentedComment #3
nplowman CreditAttribution: nplowman commentedI'm experiencing this same problem. Will re-post if I find a solution.
Comment #3.0
nplowman CreditAttribution: nplowman commentedThe request has not caught any remarks. Thus I have simplified the description.