Need an overload for Group By Projection?
On Wed, Oct 29, 2008 at 1:04 AM, Will Shaver <[EMAIL PROTECTED]> wrote:
>
> The easiest way that comes to mind would be to map a read-only
> property to a sql conversion Convert('dd', OrderDate)
>
> <property name="OrderDay" formula="Convert('dd', OrderDate)" type="Int"/>
>
> The Convert('dd' OrderDate) might vary depending on your backing db.
>
> You could then reference OrderDay in your criteria queries.
>
> On Tue, Oct 28, 2008 at 3:40 PM, Mauro <[EMAIL PROTECTED]> wrote:
> >
> > HI
> > I have a question for you monster of nhibernate ;-)
> >
> > I try to make a quey with HQL dialects where I have group by date.
> > I try to explain better:
> > I have a field.. let call it: OrderDate in Order class in this field
> > is stored the date in format like "28/10/2008 15:51:15"
> > How can retrive and group only by DAYS ?
> > as result's example will be like this :
> > (sum) (day)
> > 5 27
> > 13 28
> > 10 29
> > 11 30
> > 9 31
> > 10 1
> > etc..
> >
> > Is it possible ?
> >
> > thanks
> >
> > >
>
> >
>
--
Tuna Toksöz
Typos included to enhance the readers attention!
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
