FYI, the issue is fixed! http://nhjira.koah.net/browse/NH-1877
Thanks On Jul 9, 9:51 am, Darius Damalakas <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
