Group By a query item

[seemap]

Hi All
How do i group by a query item in a query subject in Framework manager?
Thanks
SP

 

[blom0344]

Do you mean that you want to use an aggregate SQL expression (where a 'group by' is mandatory)?



Ties Blom

 

[seemap]

I have a SQL expression which i want to use in Framework Model. This expression has 'Group By' in it.
So how do i do the same in the model. Do i use the determinants for this?
Thanks
SP

 

[blom0344]

Nope, a group by indicates an aggregate (if you are using SQL properly) You should define this as a query subject in the datalayer.


Ties Blom

 

[seemap]

Thanks Blom,
Can you elaborate how to define this as a query subject in the database layer. I am new to this tool.
SP

 

[blom0344]

When you create a new query subject you have 3 options:

(1) Model (based on existing objects)
(2) Manually build an SQL query
(3) Stored procedure

In your case use option 2..

Ties Blom