What about HQL? ALogs and AOtherLogs are mapped as collections.
Is it possible? On Apr 30, 10:05 am, Joe <[email protected]> wrote: > Is a projection query like this possible in NH? > > select > a.*, > al.cnt, > aol.cnt > from A a > left outer join ( > select id, count(*) as cnt from ALogs al group by id > ) al on a.id = al.id > left outer join ( > select id, count(*) as cnt from AOtherLogs aol group by id > ) aol on a.id = aol.id > > As far as I can tell, I can only do a column sub-query (inefficient) > or I can do the aggregate in the main select (fails when I need > multiple aggregates, also somewhat inefficient to group by loads of > columns). > > I've been mapping views to do this, but have been wondering if it is > possible with ICriteria + DetachedCriteria. > > Thanks. > > -- > You received this message because you are subscribed to the Google Groups > "nhusers" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group > athttp://groups.google.com/group/nhusers?hl=en. -- You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/nhusers?hl=en.
