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

STNyborg’s picture

Would 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

STNyborg’s picture

Status: Active » Closed (cannot reproduce)
nplowman’s picture

I'm experiencing this same problem. Will re-post if I find a solution.

nplowman’s picture

Issue summary: View changes

The request has not caught any remarks. Thus I have simplified the description.