It seems your looking for some sort of database view functionality. This could be addressed in the database by a really snappy stored procedure, if your database supports it and you've got a DBA handy to build it, or possibly through building temporary tables.
Another possibility would be building a new model that tracks event times, and modifying your seperate controllers to create new entries on valid saves (or edits). A third simple sugestion seems closest to what you need: 1) Create a table-less controller, which, for your action, queries your 3 or 4 or whatever regular models for their time limited and sorted data, 2) Then in the same action you roll your own Dataset with a couple of loops and tests, or a fancy array merge as you mention. 3) Either way, you'd let the view just operate on the merged result data. Jeff On Sep 22, 9:28 am, benr <[EMAIL PROTECTED]> wrote: > I'm looking for a way for an admin to get get all the recent activity > across multiple content types in one large list. > > I have multiple tables containing different content types (subpages, > news, events, etc) all of which have similar fields (name, crated, > status, user_id). Is there a way to find all the most recent activity > from those tables and combine the results into one large list that is > sorted by created date? > > I'm not sure if I'm missing something obvious that cake has already > built in or if I will just need to do an array merge or something. > > Thanks in advance for the advice. > > Ben --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
