[SOLVED] Grouping

Sorry, my mistake, after two days applying avery patch to CCK 2.9 I lost track of what I was actually doing...

still the problem remains

ok, I get rid of the nid and date,
date was coming from the sorting setting (nid I don't know but is gone)
manually applied the patch from the post quoted in #1
but still have issues

I have only
2 fields set: Content:Number and Content:Type
1 Filter: Node:Type

I set Content:Number as SUM but I see that in the query the Group By statement has both Content:Number and Content:Type, so the Number is summed only if both Type and Number are the same

thanks for the time you are taking to answer me but I still can't make it working.
I updated everything to the latest revision. For what I understand from this post http://drupal.org/node/695298
a patch to cck must be applied, did that also.
Now if I set something like picture 01
the resulting query is

SELECT SUM(node_data_field_ball_num.field_ball_num_value)
AS node_data_field_ball_num_field_ball_num_value, node_data_field_ball_num.field_ball_num_value
AS node_data_field_ball_num_field_ball_num_value_1
FROM node node 
LEFT JOIN content_field_ball_num node_data_field_ball_num
ON node.vid = node_data_field_ball_num.vid
WHERE node.type in ('', '', '', 'ingresso')
GROUP BY node_data_field_ball_num_field_ball_num_value_1

as you see I still get in the group by the field I am summing on, this means I can sum rows where the number is the same

still no luck
I still have a field both in the SUM and the GROUP BY statement

is there any way I can manually change the query? Not a perfect solution, but good enough to make me able to deliver the final product

Some news on this issue

I was following step by step the code to understand what was going on and I stepped into something I don't understand
this is the query up to now

SELECT node_data_field_tipo.field_tipo_nid
    AS node_data_field_tipo_field_tipo_nid,
  MAX(node.nid)
    AS nid, node_data_field_luogo.field_luogo_nid
    AS node_data_field_luogo_field_luogo_nid,
  SUM(node_data_field_ball_num.field_ball_num_value)
    AS node_data_field_ball_num_field_ball_num_value, node_data_field_ball_num.field_ball_num_value
    AS node_data_field_ball_num_field_ball_num_value_1
    FROM node node
      LEFT JOIN content_field_tipo node_data_field_tipo
        ON node.vid = node_data_field_tipo.vid
      LEFT JOIN content_type_ingresso node_data_field_luogo
        ON node.vid = node_data_field_luogo.vid
      LEFT JOIN content_field_ball_num node_data_field_ball_num
        ON node.vid = node_data_field_ball_num.vid
    WHERE node.type in ('ingresso')
    GROUP BY node_data_field_tipo_field_tipo_nid, node_data_field_luogo_field_luogo_nid, node_data_field_ball_num_field_ball_num_value_1

a "node_data_field_ball_num_field_ball_num_value_1" is present that actually should not exist.
It is created by the following line

        $handlers[$id]->query($this->display_handler->use_group_by());

in view.inc file
this line is run for each field: nid, tipo, luogo, ball_num. Every other field returns a single object placed in query[fields], but ball_num, that returns 2 objects ball_num and ball_num_1.

I'm pretty sure that is the problem, since ball_num_1 should be not there.

Anyone with some sugestions

ok, found out what the problem was and found a fix

I went deeper in the code and found out the alias_01 was created in views_plugin_query_default.inc around the end of function add_field (about line 700). The problem was that the function is called twice for each field (don't ask me why), and in the said function there is a check whether the second time the field is the same, but according to the $field_info variable the second time there is no reference to the aggregation function so the fields are seen as different and the alias_01 pops out.

thanks to an hint here http://drupal.org/node/695298#comment-4917872, which at first I supposed not relevant, I applied the patch here
http://drupal.org/node/1073350#comment-4350016 and now things seem to work smoothly.

In the end I'm working with CCK 6.x-2.8 and Views 6.x-3.x-dev

Sorry, changed the title forgot to change the status