Hello,
I'm happy with the plugin_wiki jqgrid widget.
Yet consider(genrated from wizard):
db.define_table('t_piece',
Field('id','id',
represent=lambda id:SPAN(id,'
',A('view',_href=URL('piece_read',args=id)))),
Field('f_code', type='string', unique=True,
label=T('Code')),
Field('f_reception', 'date',
label=T('Reception')),
Field('f_type', type='reference t_modele',
label=T('Type')),
Field('f_rque', type='string',
label=T('Rque')),
Field('f_etat', type='string',
label=T('Etat')),
Field('active','boolean',default=True,
label=T('Active'),writable=False,readable=False),
Field('created_on','datetime',default=request.now,
label=T('Created On'),writable=False,readable=False),
Field('modified_on','datetime',default=request.now,
label=T('Modified On'),writable=False,readable=False,
update=request.now),
Field('created_by',db.auth_user,default=auth.user_id,
label=T('Created By'),writable=False,readable=False),
Field('modified_by',db.auth_user,default=auth.user_id,
label=T('Modified By'),writable=False,readable=False,
update=auth.user_id),
format='%(f_code)s',
migrate=settings.migrate)
................................................
db.define_table('t_modele',
Field('id','id',
represent=lambda id:SPAN(id,'
',A('view',_href=URL('modele_read',args=id)))),
Field('f_nom', type='string',
label=T('Nom')),
Field('f_qstock', type='string',
label=T('Qstock')),
Field('f_qmin', type='string',
label=T('Qmin')),
Field('f_descriptif', type='string',
label=T('Descriptif')),
Field('f_materiel', type='list:reference t_materiel',
label=T('Materiel')),
Field('f_fournisseur', type='string',
label=T('Fournisseur')),
Field('f_px_unit', type='string',
label=T('Px Unit')),
Field('active','boolean',default=True,
label=T('Active'),writable=False,readable=False),
Field('created_on','datetime',default=request.now,
label=T('Created On'),writable=False,readable=False),
Field('modified_on','datetime',default=request.now,
label=T('Modified On'),writable=False,readable=False,
update=request.now),
Field('created_by',db.auth_user,default=auth.user_id,
label=T('Created By'),writable=False,readable=False),
Field('modified_by',db.auth_user,default=auth.user_id,
label=T('Modified By'),writable=False,readable=False,
update=auth.user_id),
format='%(f_nom)s',
migrate=settings.migrate)
When I use in a view (loop):
{{=db.t_piece.f_type.represent(row.f_type)}} everything is all right I
get f_nom for f_type representation.
now consider:
{{=plugin_wiki.widget('jqgrid',table='t_piece')}}
Values of db.t_piece_f_type are correctly represented but :
If I want to use the search function with db.t_piece.f_type, I will
have to search for db.t_model.id and not db.t_model.f_nom
Is there a way to achieve this ?
Thanks for this great framework.
