Re: [web2py] Re: smart grid

2020-07-18 Thread AGRogers
Great On Sat, 18 Jul 2020 at 22:35, T.R.Rajkumar wrote: > Thank you AGRogers. It works. > > -- > 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) > --- >

[web2py] Re: smart grid

2020-07-18 Thread T.R.Rajkumar
Thank you AGRogers. It works. -- 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 "

Re: [web2py] Re: smart grid

2020-07-18 Thread AGRogers
This is how i do something similar in one of my tables: db.define_table('OrganisationUser', Field(.), format = lambda r: ("%s [%s]") % (db.auth_user(r.UserID).DisplayName, db.Organisation(r.OrganisationID).ShortName) ) For you maybe: db.define_table('pm_equip', Field(.) . format

[web2py] Re: smart grid

2020-07-18 Thread T.R.Rajkumar
Thank you villas. The dblc I am using a view and referencing that views lc_no in my table pm_events. I shall try how it works and if not I will go as you said. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://co

[web2py] Re: smart grid

2020-07-17 Thread T.R.Rajkumar
Thank you AGRogers As you said the equipment record format to include the location, that would do for me. Can you please tell how to do that. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/we

[web2py] Re: smart grid

2020-07-17 Thread villas
It seems that you are using two DBs (db and dblc). In my experience, you cannot make relationships across two distinct DBs. Suggestion: 1. Create a set of all the lc_vw_lc_master.lc_no possibilities 2. Create a normal string field for pm_events.lc_no with a IS_IN_SET validator. If the recor