I have multiple tables each with created_at field. I need to retrieve data from all of them and display them arranged according to time they were created. This is something like in facebook.com's status page.
halfer Messages: 9535 Registered: January 2006 Location: West Midlands, UK
I'd create a database view that joins them together using UNION, and then add the view into the schema so it can be paged in the normal way. So if you use Propel, you can use sfPropelPager with the view, and just treat it as read-only.Remember Palestine
and used UNION to create a view. However, the id filed that comes from both tables can have the same values, but symfony considers it as a primary_key. Tried to rename id field, but then symfony adds id fiels in base classes which again causes errors.