How did you insert icons for edit in your form
I am using SQLFORM.smartgrid and I want my grid to be more bootstrap like.
Also I am having problems with displaying my child table fields (They are
not displayed :))
Any suggestions?
Here is my code
workers = db(db.worker.w_organisation == 10).select(db.worker.id,
db.worker.w_organisation, db.worker.w_first_name,
db.worker.w_last_name,db.worker.w_nick_name,db.worker.w_email,db.worker.w_status,db.worker.w_note).as_list()
#Define the query object. Here we are pulling all contacts having date of
birth less than 18 Nov 1990
query = ((db.worker.w_organisation == 10) )#&
(db.worker.w_status==db.status.s_id_s))
#Define the fields to show on grid. Note: (you need to specify id field in
fields section in 1.99.2
fields = (db.worker.id,db.worker.w_first_name,
db.worker.w_last_name,db.worker.w_nick_name,db.worker.w_email,db.status.s_code,db.worker.w_note)
#Define headers as tuples/dictionaries
headers = {'worker.id' : 'Id',
'worker.w_first_name' : 'Ime',
'worker.w_last_name' : 'Priimek',
'worker.w_nick_name' : 'Vzdevek',
'worker.w_email' : 'E-posta',
'status.s_code': 'Status',
'worker.w_note' : 'Komentar' }
#Let's specify a default sort order on date_of_birth column in grid
default_sort_order=[db.worker.w_last_name]
form = SQLFORM.smartgrid(db.worker,fields = fields,headers=
headers,linked_tables=['status'])
And db.py
db.define_table('worker',
Field('id', type ='id'),
Field('w_organisation', type ='integer'),
Field('w_user', type ='integer'),
Field('w_status', 'reference status'),
Field('w_first_name',type='text'),
Field('w_last_name',type='text'),
Field('w_nick_name',type='text'),
Field('w_email',type='text'),
Field('w_note',type='text'),
migrate=settings.migrate
)
db.define_table('status',
Field('s_id_s', type ='id'),
Field('s_code', type ='text'),
Field('s_description', type ='text'),
migrate=settings.migrate
)
thank you
best regards
On Friday, September 21, 2012 5:58:05 PM UTC+2, Adi wrote:
>
> I'm wondering what to do in this situation? I have self-referencing fields
> in the child table, and due to that smartgrid display links, which
> basically can't do anything.
>
> I'm trying to eliminate them, but not sure what would be a proper way?
>
> Thanks.
>
> Simplified code sample:
> db.define_table('campaign',
> Field('tbl_uuid', length=64, default=lambda:str(uuid.
> uuid4())),
> Field('name','string', label=T('Campaing Name')),
> format='%(name)s',
> )
>
> db.define_table('message',
> Field('tbl_uuid', length=64, default=lambda:str(uuid.
> uuid4())),
> Field('name','string', label=T('Name')),
> Field('campaign_id', 'reference campaign', label=T(
> 'Campaign')),
> Field('action_yes_id', 'reference message)',
> label=T('Action
> Yes'),),
> Field('action_no_id', 'reference message)',
> label=T('Action
> No')),
> migrate=True)
>
>
>
> grid=SQLFORM.smartgrid(Campaign, details=False, links_in_grid=True,
> linked_tables=['message'],
> # linked_tables=dict(campaign=['message'],
> message=['']),
> links=dict(campaign=[lambda row:(_get_messages(row))
> ]),
> )
> Enter code here...
>
>
>
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
