[sqlalchemy] Correlated sub-query as ORM query filter

2010-02-23 Thread David Bolen
Hopefully this won't just be a section in the manual I missed, but I'm having some difficulties constructing an ORM query while using correlated sub-queries within filter(). This is with SA 0.5.8. Given the following tables (with just the relevant columns shown): attendance (

Re: [sqlalchemy] Correlated sub-query as ORM query filter

2010-02-23 Thread Michael Bayer
On Feb 23, 2010, at 5:23 PM, David Bolen wrote: But various attempts to use these queries in a filter() portion of the original query always result ArgumentError exception that filter() argument must be of type sqlalchemy.sql.ClauseElement or string I figured I'm missing some magic method