Hi.
I have clients(table) with address(related one-to-one) and
persons(related one-to-many)..
I want to do this:
results =
ses.query(b.Client).filter(b.Client.address_id==b.Address.id).\
filter(b.Client.id==b.Client_person.client_id).filter(or_(*cols)).all()
Using only:
results = ses.query(b.Client).filter(or_(*cols)).all()
where *cols is for example:
b.Address.name.like('%address%')
or
b.Client_person.surname.like('%surname%')
...
When I do not specify the "join filter", I get all companies...
With "join filter", everything works fine.
Is there a way to not specify the "join filters" explicitly??
thx
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalchemy@googlegroups.com
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
-~----------~----~----~----~------~----~------~--~---
