errata:
Hello Debebe,
I apologize. If I understand your question as well as the context....
1) get latest web2py (1.83.1 or later)
2) install plugin_wiki as explained in chapter 13 of the book.
3) Then create the following action:
def getrecord():
tablename=request.args(0)
if not tablename in db.tables(): redirect(URL('error')) # table
does not exist
record = db[tablename](request.args(1)) or
redirect(URL('error')) # record does not exist
form = crud.read(db[tablename], record) # or crud.update
referenced_tablename={'a':'b','b':'c','c':'d'}[tablename] #
table to be listed
referenced =
plugin_wiki.widget('jqgrid',table=db[referenced_tablename],fieldname=tablename,fieldvalue=record.id)
# embeds a jqgrid with records referencing current one
return dict(form=form,referenced=referenced)
then you can use
http://..../<yourapp>/default/getrecord/<tablename>/<record_id>
Hope this helps.
On Aug 29, 11:06 am, mdipierro <[email protected]> wrote:
> Hello Debebe,
>
> I apologize. If I understand your question as well as the context....
>
> 1) get latest web2py (1.83.1 or later)
> 2) install plugin_wiki as explained in chapter 13 of the book.
> 3) Then create the following action:
>
> def getrecord():
> tablename=request.args(0)
> if not tablename in db.tables(): redirect(URL('error'))
> record = db[tablename](request.args(1)) or
> redirect(URL('error'))
> form = crud.read(db[tablename], record) # or crud.update
> referenced_tablename={'a':'b','b':'c','c':'d'}[tablename]
> referenced =
> plugin_wiki.widget('jqgrid',db[other_tablename],fieldname=tablename,fieldvalue=record.id)
> return dict(form=form,referenced=referenced)
>
> then you can use
>
> http://..../<yourapp>/default/getrecord/<tablename>/<record_id>
>
> Hope this helps.
>
> Massimo
>
> On Aug 17, 6:05 pm, dbb <[email protected]> wrote:
>
> > Massimo,
>
> > I sent you a message yesterday on the same issue,
>
> > a is table
> > b is table referencing a
> > c is a table referencing b
> > d is a table referencing c
>
> > I want all child tables to be displayed under their parents, we the
> > parent has data, the children are visible and one can update the data
> > in the children. This is the same as web2py HL7 application we had.
> > I am trying to group the table as specified above. Any help is
> > appreciated, you can send me the answer. This is to update the
> > application by adding more stuffs from HL2.5. This approach makes the
> > view to display small number of file.
>
> > Debebe
