Hi,
But, how do i insert the func.count(x).label('whatever') into a
Query(User) ?
User is an assign_mapper based obj. I dont think i can use
Select([func.count(x)]).query() since that wont return a list User
objects i believe. So, still trying to see how to fit what you said
into my query like:
q =
Query(cls).join('parent').group_by(cls.c.user_id).order_by(func.count(cls.c.user_id)).limit(limit).offset(offset)
thanks
On 4/29/07, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
> On Apr 29, 2007, at 1:07 AM, Ram Yalamanchili wrote:
>
> >
> > 1) select a func.count() column
> > 2) Name an alias to it
> > 3) use this alias with a .order_by
> >
>
>
> func.count(x).label('whatever')
>
>
> then
>
> order_by('whatever')
>
> (or order_by=['whatever'], depending on context)
>
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
