on 09-17-2008 7:41 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.