Have you tried something like: query1=((db.vehicle.id==db.owner.own_veh_fk)&(db.owner.own_end_date!=None))
query2=(~db.vehicle.id.belongs(db(db.owner.own_veh_fk==db.vehicle.id )._select(db.vehicle.id))) query = query1 & query2 db.owner.own_veh_fk.requires=IS_IN_DB(query,'vehicle.id', '%(manufacturer)s %(vin)s') 2014-05-28 20:47 GMT-03:00 <98uj...@gmail.com>: > Thank you Mr. Massimo and your colleagues for bringing the web2py to the > masses. > I need to have a field that will present a choice of values that result > from a union of query1 and query2 > How can i create a set that would go where the question mark is? Thanks > for any help! > > query1=((db.vehicle.id > ==db.owner.own_veh_fk)&(db.owner.own_end_date!=None)) > > query2=(~db.vehicle.id.belongs(db(db.owner.own_veh_fk==db.vehicle.id > )._select(db.vehicle.id))) > > db.owner.own_veh_fk.requires=IS_IN_DB((db(?)),'vehicle.id', > '%(manufacturer)s %(vin)s') > > -- > 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 web2py+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/d/optout. > -- Att. Carlos J. Costa Cientista da Computação Esp. Gestão em Telecom EL MELECH NEEMAN! אָמֵן -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
