I want to create an one2one relation between two objects (hr_recruitment_stage and hr_job).
Any suggestion?
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Contabilidad
- Inventario
- PoS
- Project
- MRP
Se marcó esta pregunta
Hi,
Odoo ORM doesn’t support One2one fields, but you can do them manually. In the example below we make one2one relationship between models hr.recruitment.stage and hr.job.
In short, you set normal Many2one field (stage_id in the example) in a one model (doesn’t really matter which of the models you choose) and corresponding One2many field (stage_ids in the example) in another model. Then we add virtual Many2one field (job_id in the example) with attributes compute and inverse.
class HrRecruitmentStage(models.Model):
_name = 'hr.recruitment.stage'
job_id = fields.Many2one('hr.job', compute='compute_stage', inverse='stage_inverse')
stage_ids = fields.One2many('hr.job', 'stage_id')
@api.depends('stage_ids')
def compute_stage(self):
if len(self.stage_ids) > 0:
self.job_id = self.stage_ids[0]
def stage_inverse(self):
if len(self.stage_ids) > 0:
# delete previous reference
stage = self.env['hr.job'].browse(self.stage_ids[0].id)
asset.stage_id = False
# set new reference
self.job_id.stage_id = self
class HrJob(models.Model):
_name = 'hr.job'
stage_id = fields.Many2one('hr.recruitment.stage', string='Stage')
Hope it helps
Thank you for your help, can you also implement this using odoo online studio?
Stumbling upon this many years later, but I think perhaps an easier way is to use _sql_constraint, this should enforce a one to one relationship in the database.
So you could use:
_sql_constraints = [('make some_id one2one', 'unique(some_id)', 'some_id must be unique to ensure one2one relationship')]
some_id = fields.Many2one(...)
¿Le interesa esta conversación? ¡Participe en ella!
Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.
RegistrarsePublicaciones relacionadas | Respuestas | Vistas | Actividad | |
---|---|---|---|---|
|
2
abr 25
|
452 | ||
|
1
abr 25
|
353 | ||
|
2
feb 24
|
1478 | ||
|
1
jul 23
|
1713 | ||
|
2
jun 23
|
2375 |