[TurboGears] Re: SQLObject : subselect joins orderby

[william]

I don't know if I understand your point correctly, but to get the last
modified pages, I would do:

class Page(SQLObject):
        pagename = StringCol(alternateID=True, length=30)
        entries = MultipleJoin('Entry')

class Entry(SQLObject):
        class sqlmeta:
            defaultOrder = "-mod_date_time"
        page = ForeignKey('Page')
        data = StringCol()
        mod_date_time = DateTimeCol(default=datetime.now())


recentupdate=Entry.select()[:10]
recentpages=[p.pagename for p in recentupdate.page]

PS: I've just type it like it come in my head ... not tested!!!!

William