When I tried to use this module it generated a GROUP BY with an additional field on the end that broke it:

e.g. The node_vid on the end of the GROUP BY field list.


SELECT
COUNT(node.nid) AS nid,
node_data_field_contractor.field_contractor_nid AS node_data_field_contractor_field_contractor_nid,
node_data_field_contractor.delta AS node_data_field_contractor_delta,
node.type AS node_type,
node.vid AS node_vid
FROM node node
LEFT JOIN content_field_contractor node_data_field_contractor
ON node.vid = node_data_field_contractor.vid
WHERE node.type IN('enquiry')
GROUP BY node_data_field_contractor_field_contractor_nid, node_data_field_contractor_delta, node_type, node_vid
ORDER BY node_data_field_contractor_field_contractor_nid DESC


The Views Group By module is useful not only in the cases where all you want out of the view is a count but also for general Group By clause needs. You just have to throw away the output of the sum() function.

I have an Ubercart checkout screen, and on it, I am displaying all Orders for the current user along with all order details (node product title, product download links). The issue I was running into without some Group By clause is that the Order Id was repeating for each node represented in the cart.. Views Group By helped me to solve this by Group On Order Id, Aggregate with SQL Function on Order Creation Date. However, this shows Dec 1969 for all order dates... So I tossed in an additional Order Creation Date field (referred to as [created_1] in my Order By rewritten field), and life was good again.

If you just want to 'group' and list your results by criteria (say day, author or tag), you don't need views_groupby.
This is available in Views already, but not in 'Filter or 'Sort' where you may look for it - it's in the setting for "Style" in the "Basic Settings". There you can find a way to define a "Grouping Field"

Hi,

I am trying to group the cck field (Type : Select list) but it seems its not working or
might be I am missing something.

Below is my sql code (generated by view)

SELECT COUNT(node.nid) AS nid,
node.type AS node_type,
node_data_field_type.field_type_value AS node_data_field_type_field_type_value,
node.vid AS node_vid
FROM node node
LEFT JOIN content_type_project node_data_field_type ON node.vid = node_data_field_type.vid
GROUP BY node_data_field_type_field_type_value, node_type, node_vid
ORDER BY nid ASC

In the result each node comes as separate unique item and they are not getting group by cck field for
some reason. Any help is highly appreciated.

Thank you a million times over! This little module was a real time saver for me.

SELECT node.nid AS nid,
node_data_field_from.field_from_nid AS node_data_field_from_field_from_nid,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_to.field_to_nid AS node_data_field_to_field_to_nid,
node_data_field_vehicle_number.field_vehicle_number_value AS node_data_field_vehicle_number_field_vehicle_number_value,
node.created AS node_created,
node_data_field_delivery.field_delivery_value AS node_data_field_delivery_field_delivery_value
FROM node node
INNER JOIN content_type_challan node_data_field_delivery ON node.vid = node_data_field_delivery.vid
LEFT JOIN content_field_from node_data_field_from ON node.vid = node_data_field_from.vid
LEFT JOIN content_field_to node_data_field_to ON node.vid = node_data_field_to.vid
LEFT JOIN content_type_challan node_data_field_vehicle_number ON node.vid = node_data_field_vehicle_number.vid
WHERE (node.status <> 0) AND (node.type in ('challan')) AND (node.nid IN (772,773,618,818,6852,940,6855,771,869,770,768,767,766,86751082)) AND (node_data_field_delivery.field_delivery_value = 'Dispatched')";
ORDER BY node_created DESC

bug is:
Group By only node_data_field_vehicle_number,node_created
node_data_field_from.field_from_nid AS node_data_field_from_field_from_nid,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_to.field_to_nid AS node_data_field_to_field_to_nid,
node_data_field_vehicle_number.field_vehicle_number_value AS node_data_field_vehicle_number_field_vehicle_number_value

SELECT node.nid AS nid,
node_data_field_from.field_from_nid AS node_data_field_from_field_from_nid,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_to.field_to_nid AS node_data_field_to_field_to_nid,
node_data_field_vehicle_number.field_vehicle_number_value AS node_data_field_vehicle_number_field_vehicle_number_value,
node.created AS node_created,
node_data_field_delivery.field_delivery_value AS node_data_field_delivery_field_delivery_value
FROM node node
INNER JOIN content_type_challan node_data_field_delivery ON node.vid = node_data_field_delivery.vid
LEFT JOIN content_field_from node_data_field_from ON node.vid = node_data_field_from.vid
LEFT JOIN content_field_to node_data_field_to ON node.vid = node_data_field_to.vid
LEFT JOIN content_type_challan node_data_field_vehicle_number ON node.vid = node_data_field_vehicle_number.vid
WHERE (node.status <> 0) AND (node.type in ('challan')) AND (node.nid IN (772,773,618,818,6852,940,6855,771,869,770,768,767,766,86751082)) AND (node_data_field_delivery.field_delivery_value = 'Dispatched')";
ORDER BY node_created DESC

bug is:
Group By only node_data_field_vehicle_number,node_created
node_data_field_from.field_from_nid AS node_data_field_from_field_from_nid,
node.type AS node_type,
node.vid AS node_vid,
node_data_field_to.field_to_nid AS node_data_field_to_field_to_nid,
node_data_field_vehicle_number.field_vehicle_number_value AS node_data_field_vehicle_number_field_vehicle_number_value

This issue has been moved to the Issues section: http://drupal.org/node/1142074