On Tuesday, May 8, 2012 6:48:34 AM UTC-4, Khalil KHAMLICHI wrote: > > I generate a drop down menu with this line of code >> >> db.files.project.requires = IS_IN_DB(db, 'projects.id', '%(project)s', >> zero='...') > > > how do I add a filter like : (db.projects.deleted==False) to filter out > the records displayed by the drop down menu ? >
IS_IN_DB(db(db.projects.deleted==False), 'projects.id', '%(project)s', zero= '...') IS_IN_DB takes a DAL Set object as the first argument, which can be used to filter the set of records used to create the list. See http://web2py.com/books/default/chapter/29/7#Database-validators. Anthony
