[web2py] SQLFORM.grid with reference

[__pyslan__ - Ayslan Jenken]

Hello, everyone.

I have the following Models:


Category = db.define_table('category',
        Field('categ_id', 'integer', notnull=True, label=T('Category')),
        Field('name', 'string', notnull=True, label=T('Name')),
        format="%(name)s"
)

Reading = db.define_table('reading',
        Field('serie_number', 'integer', notnull=True, label=T('Serie
Number')),
        Field('categ_id', 'reference category', required=IS_IN_DB(db,
'category.categ_id', '%(name)s')),
        Field('group_partner', db.auth_group, label=T('Group Partner')),
        Field('software_version', 'integer', notnull=True,
label=T('Software Version')),
        Field('counter_inputs', 'integer', notnull=True, label=T('Counter
Inputs')),
        Field('number_checker', 'integer', notnull=True, label=T('Number
Checker'))
)

But when I put it in a SQLFORM.grid as follows:

headers = {
                Reading.serie_number:T('Serie Number'),
                Category.name:T('Category'),
                Reading.software_version:T('Version'),
                Reading.counter_inputs:T('Inputs'),
                Reading.number_checker:T('Checker')
}

fields = [
                Reading.serie_number,
                Category.name,
                Reading.software_version,
                Reading.counter_inputs,
                Reading.number_checker
]


queries = []
queries.append(Reading.group_partner == group_partner) # group_partner aqui
é uma variável vinda da session.
queries.append(Reading.categ_id == Category.categ_id)

query = reduce(lambda a, b: (a & b), queries)
return dict(table=SQLFORM.grid(query, csv=False, fields=fields,
headers=headers))


Here are the questions:

1 - headers do not work. Are displayed the labels defined in the models.
2 - When I click add, edit or view, is not done for the table Reading, but
for the Category table.


If anyone can help me, thank you!


Regards,

__pyslan__


PS Sorry for my English!

--