Re: [web2py] Virtual field in SQLFORM.grid

I could make it work. Changed the virtual field from: Field.Virtual('total', lambda row: row.trabalho.konsulta.count()), To: Field.Virtual('total', lambda row: db((db.konsulta.trabalho_id== row.trabalho.id)).count()) Both fields work in the shell, but just the second works in the grid... Can

Re: [web2py] Virtual field in SQLFORM.grid

In other words... Is there a way to show a total of the child table in each row of the master table (grid) ?? Thanks On Tuesday, January 19, 2016 at 5:52:51 PM UTC-2, Marcello wrote: > > Yes. I can see the tables... > And yes... I can call the function.. It's working OK... > > Thanks... > >

Re: [web2py] Virtual field in SQLFORM.grid

Yes. I can see the tables... And yes... I can call the function.. It's working OK... Thanks... On Tue, Jan 19, 2016 at 4:39 PM, Fabiano Almeida wrote: > Hi Marcello, > > Can you see your tables in appadmin? > > And your lambda, you can create and call function to count

Re: [web2py] Virtual field in SQLFORM.grid

Hi Marcello, Can you see your tables in appadmin? And your lambda, you can create and call function to count in konsulta's table and return the number. Field.Virtual('total', lambda row: kontagem(row.id)) Att., Fabiano. 2016-01-19 15:09 GMT-02:00 Marcello : > Hello, > >

[web2py] Virtual field in SQLFORM.grid

Hello, I have a one to many configuration, using mysql database. I want to show a grid with the "one" table, and for each row, count the "many". For that I created a total virtual field. It works OK in the shel, for example But when I call the SQLFORM.grid I get an error Why do this

[web2py] Virtual Field and sqlform.grid

Whe I use a table that has some a virtual field sqlform.grid does not works type 'exceptions.AttributeError' 'Row' object has no attribute 'unknown' and that happens only when the virtual field is uncommented def get_category_list(post): category_id_list = db(db.Post_in_category.post_id ==