Use belongs (http://web2py.com/books/default/chapter/29/06#belongs)
db(db.Articles.User.belongs([make,user_ids,into,a,list])).select() On Saturday, September 8, 2012 9:48:43 PM UTC+8, BlueShadow wrote: > > I got a table for articles which contains an ids of users which commented > on that particular image. > now I like to read all the user ids of an particular aricle and display a > list off all articles those users commented on. > here is my first attempt: but its pretty aweful: > db.define_table('Article', > Field('Title'), > Field('content','blob'), > Field('Users','list:reference auth_user'), > > Field('Submitted','datetime',default=datetime.datetime.now(),writable=False,readable=False) > ) > model: > > def displaylist(): > id=request.vars.id > row=db(db.Articles.id==id).select() > row=row[0] > Userids=row.Users > related=[] > for i in Userids: > related.append(db().select(db.Articles.User,i)) > return dict(originalArticle=row,related=related) > > view: > {{for i in related:}} > {{#=some funky select}} > {{pass}} > --