*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]'
> )
>
>
>
>
>
>
