Hi,
I am trying to reuse my column list in my group by clause but some of my
columns use label() which is causing a sql syntax error because of the
"column as label" in the group by clause. Is it possible to get the
group_by to only use the "label" side of a column .
eg. (This doesn't work because of the "labels"
group_by = [
service.date,
service.client_id,
service_type.type_code,
service.service_code,
client.code.label('client_code'),
client.name.label('client_name'),
func.coalesce(func.nullif(client_rate.description, ''),
service_type.description).label('service_description'),
service.rate_amt
]
columns = group_by[:].extend([
func.sum(service.quantity).label('quantity'),
func.sum(service.service_amt).label('service_amt')
])
s = select(columns, criteria,
from_obj=[outerjoin(db.service_table, db.client_rate_table),
db.job_table, db.client_table, db.service_type_table],
group_by=group_by,
order_by=[service.date, client.name, service.service_code]
)
Many thanks,
Huy
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
