Please complete this code.. [終了済]
2013/03/22 4:37
1,316 ビュー
The question has been closed for reason: not a real post
by
Fabien Pinckaers (fp)
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
priyankahdp
this is a first field..it search for non parent id record.thatswhy i state that any issue with it.?
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'.