Via Projections.SqlFunction,
Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs/tuna_toksoz http://tunatoksoz.com http://twitter.com/tehlike On Fri, May 1, 2009 at 11:13 PM, Jason Meckley <[email protected]>wrote: > > the following query fails: > > var results = DetachedCriteria > .For<OrderLine> > .SetProjection(Projections > .ProjectionList() > .Add(Projections.GroupProperty("item.category")) > .Add(Projections.GroupProperty("order.sales_date")) > .Add(Projections.Sum("quantity*item.unit_factor"))) > .CreateAlias("order", "order") > .CreateAlias("item", "item") > .CreateAlias("item.category", "category") > .Add(Restrictions.Between("order.sales_date", start, end)) > .Add(Restrictions.Eq("order.invoiced", true)) > .GetExecutableCriteria(session) > .List(); > > with the exception: > could not resolve property: quantity*item.unit_factor of: > SalesReports.Web.Model.Domain.OrderLine > > however the following HQL works: > > select > c, > h.sales_date, > sum(d.quantity*i.unit_factor) > from > OrderLine d > join d.order h > join d.item i > join i.category c > where > h.sales_date between :start and :end > and h.invoiced = true > group by > c.id, > c.sort_order, > c.name, > c.parent_category, > h.sales_date > > how do I fix the projection Projections.Sum > ("quantity*item.unit_factor")? > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
