Hello,
I have one table called 'Assets' with a 'category' (String) and
'created' (DateTime) column. Now I would like to find the records
created since a given datetime for each category:
This is what I thought would work (with a self-join):
session.query(Asset).join(Asset, and_(Asset.category == Asset.category,
Asset.created > specifiedDateTime)
But it does error with 'Cant find any foreign key relationships...'
How can I fix this? Or do you have a better idea how to accomplish the task?
Thank you,
Sebastian
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
