Help

Please complete this code..

Closed
Avatar
priyankahdp

The question has been closed for reason: not a real question

by
Fabien Pinckaers (fp)
on 03/22/2013 05:41:28

bpl.py class

'bpl_company_id': fields.function(_get_company_data, fnct_inv=_set_company_data, type='one2many', relation='hr.department', string="Company"),
bpl_estate_id
bpl_division_id

i need to add below sql query and retrieve companies (no parent id) then need to get estate under that selected company then division under selected estate

company - > Estate -> Division

my incomplete function

    cr.execute("""
    select * from hr_department
    where parent_id is null
    """)

return cr. fetch method..

please advice me to complete this code.try with various samples.but unable to get the result

2 Comments
Avatar
Discard
Avatar
Prakash
-

In the above Sql query where condition add "and company_id= 'id of the Estate Division' " or use left join with table res_company as company on company.name = 'estate'.

Avatar
priyankahdp
-

this is a first field..it search for non parent id record.thatswhy i state that any issue with it.?