*bump* any inputs?
On Friday, October 7, 2011, niknok wrote: > ** > I have a self-referencing table [1] with a defined format for representing > a record in this fashion: "Lastname, Firstname [yyyy-mm-dd]". In the father > field, I expect it to display the drop-down list of persons as defined in > format, but it doesn't unless I define it explicitly (like in the mother > field). > > Second, I tried dbset filter for the selection list of the father and > mother fields but I still get the whole table instead. > > I'm trying this out on v1.99.2. What am I doing wrong here? > > TIA > > [1] > db.define_table('person' > ,Field('birth_date', 'date', requires=IS_DATE()) > ,Field('last_name', notnull=True) > ,Field('given_name', notnull=True) > ,Field('middle_name', label="Mother's maiden name") > ,Field('gender', 'integer', > requires=IS_IN_SET(settings.gender, zero='pick one')) > ,Field('father', 'reference person' > ,requires=IS_EMPTY_OR(IS_IN_DB(db('person.gender'==1), > 'person.id' > ,zero=T('pick one')))) > ,Field('mother', 'reference person' > ,requires=IS_EMPTY_OR(IS_IN_DB(db('person.gender'==2), > 'person.id' > ,'%(last_name)s, %(given_name)s > [%(birth_date)s]' > ,zero=T('pick one')))) > ,auth.signature > ,format='%(last_name)s, %(given_name)s [%(birth_date)s]' > ) > > > > > >