strange query behavior

[Former Member]

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?

[dan_cuevas · Accepted solution]

Hi Farhat,

Did you try creating a query using Infoview with the same objects?

Is the resulting SQL query the same or similar on InfoView and through code?

If it is then, there is nothing we can do except modify the default SQL query that is generated.

Hope this helps.

Regards,

Dan

[Former Member · Accepted solution]

I see the same thing in InfoView. It seems like that's the default behavior.