Thank you. I filed a new ticket here: http://nhjira.koah.net/browse/NH-1877
If this could be done in two days (compared to two months), it would be great. We are adding chart support for our software, and we want them to be as flexible as possible. So for us it is necessary to use ICriteria API, and not HQL. Also conserning the issue, the group by query could be writtent in two ways. One is Fabio suggested way: select month(ro.Something) from RisingOrder ro group by month (ro.Something) Another could be with aliases, that is: select month(ro.Something) as myMonth from RisingOrder ro group by myMonth I am interested in either way, as they both solve my problem. On Jul 8, 8:25 pm, Fabio Maulo <[email protected]> wrote: > Darius if you need > Projections.GroupBy(IProjection projection) > add the JIRA as Improvement, Tuna will work on it. > Thanks. > > 2009/7/8 Tuna Toksoz <[email protected]> > > > > > As you said before, one of the targets of NH is to provide DB ignorance. > > This was the reason why we wanted to have more functions in dialects,I > > believe, so that we don't enforce the user to use an MSSQL specific > > function, for example. Having an overload that takes IProjection would serve > > this purpose. > > > My 2 cents. > > > Tuna Toksöz > > Eternal sunshine of the open source mind. > > >http://devlicio.us/blogs/tuna_toksoz > >http://tunatoksoz.com > >http://twitter.com/tehlike > > > On Wed, Jul 8, 2009 at 8:13 PM, Fabio Maulo <[email protected]> wrote: > > >> .SetProjection(Projections.SqlGroupProjection("min({alias}.Name) as > >> FirstName", "datepart(mm, {alias}.BirthDate)", > >> new[] { "FirstName" }, new[] { NHibernateUtil.String }) ) > > >> 2009/7/8 Tuna Toksoz <[email protected]> > > >>> This is not impossible to implement, is it? > > >>> select month(ro.Something) from RisingOrder ro group by month( > >>> ro.Something) > > >>> It is both in group by and in select, so it is a matter of creating an > >>> overload for both the constructor and Projections.GroupBy thing. > > >>> I still don't understand why you said this. > > >>> Tuna Toksöz > >>> Eternal sunshine of the open source mind. > > >>>http://devlicio.us/blogs/tuna_toksoz > >>>http://tunatoksoz.com > >>>http://twitter.com/tehlike > > >>> On Wed, Jul 8, 2009 at 7:28 PM, Fabio Maulo <[email protected]>wrote: > > >>>> 2009/7/8 Tuna Toksoz <[email protected]> > > >>>>> If you file a jira report, I will implement this in 2 days. > > >>>> That is because you have studied it and you know that it > >>>> is impossible with the actual implementation, right ? > >>>> Or is because create a JIRA ticket is similar to a sport ? > > >>>> -- > >>>> Fabio Maulo > > >> -- > >> Fabio Maulo > > -- > Fabio Maulo --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
