Hi!

I have 2 tables:

sortiment(id, ...) <---- translations(id, id_sortiment, language, text)

The query

query(Sortiment).outerjoin(Sortiment.translations).filter(Translation.language="en")

will never return sortiment item with missing "en" translation because
the filter (useless outerjoin). I need the Translation.language="en"
embed into the outerjoin but the language must be variable. This is a
general problem of creating variable joins on session queries.
Is there any simple way?

Thank you.

David

--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---

Reply via email to