DOH, you right... It just break lazy_table it guess, I forgot about that. Thanks Derek!
:) Richard On Thu, Sep 4, 2014 at 5:23 PM, Derek <[email protected]> wrote: > Just set that up after you define the table. > > > On Thursday, September 4, 2014 1:53:05 PM UTC-7, Richard wrote: >> >> Hello, >> >> I have a weird case where I need to make a self reference on a table but >> I need to filter out the list of table entries present in my drop down. >> >> # Model >> dummy_sub_select_set = db(db.dummy_table.field1 == True) # Not working >> dummy_sub_select_set = lambda: db(db.dummy_table.field1 == True) # Not >> working either >> >> >> db.define_table('dummy_table', >> >> Field('represent_field', ...), >> Field('field1', ...), >> Field('field2', 'reference dummy_table', >> requires=IS_IN_DB(dummy_sub_select_set, ' >> dummy_table.id', '%(represent_field)s'), >> represent=lambda value, row: A(db. >> dummy_table(id).represent_field, >> _href=URL(...)) >> if id is not None else >> T('N/A'), >> ), >> >> >> # This don't work either >> db.define_table('dummy_table', >> >> Field('represent_field', ...), >> Field('field1', ...), >> Field('field2', 'reference dummy_table', >> requires=IS_IN_DB(db(db.dummy_table.field1 >> == True), 'dummy_table.id', '%(represent_field)s'), >> represent=lambda value, row: A(db. >> dummy_table(id).represent_field, >> _href=URL(...)) >> if id is not None else >> T('N/A'), >> ), >> >> >> Is there a way to filter up the content of a "not already" define table >> with IS_IN_DB()? >> >> Thanks >> >> Richard >> > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/issues/list (Report Issues) > --- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
