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?
