Ups, my bad I tested on web2py version 1.89.5 and trunk
On Dec 8, 5:56 pm, drayco <[email protected]> wrote: > Hi > > I have this code in the model: > > db36.define_table('benefs2', > #Field('id','integer'), > Field('unique_id','string', writable=False, readable=False), > Field('active','string', writable=False, readable=False), > Field('creadoEl','datetime', writable=False, readable=False), > Field('creadoPor','integer', writable=False, readable=False), > Field('actualizadoEl','datetime', writable=False, readable=False), > Field('actualizadoPor','integer', writable=False, readable=False), > Field('reason','string', writable=False, readable=False), > Field('key_Registro','string', writable=False, readable=False), > Field('folio','integer'), > Field('dates2_id','integer', writable=False, readable=False), > Field('tramite','datetime'), > Field('entrega','datetime', writable=False, readable=False), > Field('regional_id','integer', writable=False, readable=False), > Field('coordinador_id','integer', writable=False, readable=False), > Field('parentesco','integer', writable=False, readable=False), > Field('names','string'), > Field('apelPater','string'), > Field('apelMater','string'), > Field('rfc','string'), > Field('sexo','string', writable=False, readable=False), > Field('enfermedades','integer', writable=False, readable=False), > Field('categoria','string', writable=False, readable=False), > Field('namesWorked','string'), > Field('apelPaterWorked','string'), > Field('apelMaterWorked','string'), > Field('rfcWorked','string'), > Field('domicilioWorked','string', writable=False, readable=False), > Field('cpWorked','integer', writable=False, readable=False), > Field('telWorked','double', writable=False, readable=False), > Field('celWorked','double', writable=False, readable=False), > Field('teltrabWorked','double', writable=False, readable=False), > Field('sexoWorked','string', writable=False, readable=False), > Field('delegacionCT','string', writable=False, readable=False), > Field('zona_Escolar','string', writable=False, readable=False), > Field('nivel_Educativo','string', writable=False, readable=False), > Field('subdireccion','string', writable=False, readable=False), > migrate=False) > > and this code in the controller: > > @auth.requires_membership('Ventas') > def buscar_benefs(): > form, results = crud36.search( db36.benefs2, > queries = ['contains'], > query_labels={'contains':'Contiene'}, > fields = [db36.benefs2.folio, > db36.benefs2.tramite,db36.benefs2.names,db36.benefs2.apelPater,db36.benefs2.apelMater,db36.benefs2.rfc, > \ > > db36.benefs2.namesWorked,db36.benefs2.apelPaterWorked,db36.benefs2.apelMaterWorked,db36.benefs2.rfcWorked], > field_labels = {'folio':'Folio', > 'tramite':'Fecha de > Tramite','names':'Nombres','apelPater':'Apel.Pater.','apelMater':'Aperl.Mater', > 'rfc':'RFC',\ > > 'namesWorked':'Trab.Nombres','apelPaterWorked':'Trab.Apel.Pater.','apelMaterWorked':'Trab.Aperl.Mater', > 'rfcWorked':'Trab.RFC'}, > zero='Por favor, seleccione al menos una', > query = > (db36.benefs2.id>0)&(db36.benefs2.active=='T') ) > return dict(form=form, results=results) > > I need to put writable=False and readable=False in every field of the > model because crud.serch don't respect fields and field_labels > > And I don't want to show the id and in other tables I don't want to > put in every field writable=False and readable=False. > > Can any have some advice to avoid that issue?
