Hi folks, I have a mapper that has an order by clause, and I was hoping to
get it to work with secondary sorts on the joined tables, wondering if this
is possible, or if not, how I could add some other kind of more complex
sorting?
Here's what I hoped would work but didn't:
mappers['Membership'] = mapper(Membership, membership_table, properties = {
'client': relation(Client, backref=backref('memberships',
cascade='all, delete, delete-orphan') ),
'billing_type' : relation(BillingType, backref='memberships'),
'membership_type' : relation(MembershipType, backref='memberships'),
'orgunit' : relation(Orgunit, backref=backref('memberships',
cascade='all, delete, delete-orphan') ),
'roles_assocs' : relation(MembershipsRolesAssoc, cascade='all,
delete, delete-orphan', backref='membership') # was 'memberships'
}, order_by=[membership_table.c.date_end, client_table.c.name_last] )
And the error:
OperationalError: (OperationalError) (1054, "Unknown column
'client.name_last' in 'order clause'") 'SELECT membership.id AS
membership_id, membership.client_id AS membership_client_id,
membership.orgunit_id AS membership_orgunit_id, membership.date_start AS
membership_date_start, membership.date_end AS membership_date_end,
membership.billing_type_id AS membership_billing_type_id,
membership.membership_type_id AS membership_membership_type_id,
membership.is_active AS membership_is_active, membership.notes AS
membership_notes \nFROM membership \nWHERE %s = membership.orgunit_id ORDER
BY membership.date_end, client.name_last' (21L,)
Any tips much appreciated!
thanks
Iain
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/groups/opt_out.
