strange query behavior
When adding four DataSourceObjects to my query result object list (2 being of type TEXT, 1 of DATE, and 1 of NUMERIC), the underlying code is using an aggregate (SUM) on the numeric field and grouping by the other three DataSourceObjects.
Is this the default behavior when a numeric field is added to a query?
I don't want it to sum my data or applying grouping unless I explicitly tell it to do so. Is there a way I can tell the code to stop doing this without having to modify the sql in the Query object?