Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
Hi guys,
I run on an Odoo v10, i got a situation, these are my 3 model:
allowance
name = fields.Char()
job
allowance_ids = fields.One2many('job.allowance.rel', 'job_id')
job.allowance.rel
job_id = fields.Many2one('job')
allowance_id = fields.Many2one('allowance')
value = fields.Float()
I tried to set domain on field allowance_ids to avoid duplicate allowance type but nothing work.
plz help me. Thanks!
Hello! I dont know how to set that kind of domain: but i know a walk around:
You will just need to write a constraint on job.allowance.rel , precisely on the fields job_id and allowance_id.
_sql_constraints = [
('unique_job_id_allowance', 'UNIQUE(job_id, allowance_id)', 'Cannot have many job allowance rel with exactly the same job and the same allowance')
] //This would cause an exception when you will be trying to save a job form that contains
many job.allowance.rel with the same allowance selected for the current job
Hope this would help
Create an account today to enjoy exclusive features and engage with our awesome community!
Sign up| Related Posts | Replies | Views | Activity | |
|---|---|---|---|---|
|
3
Aug 23
|
26395 | ||
|
2
Mar 16
|
28350 | ||
|
0
Feb 19
|
3398 | ||
|
2
Mar 24
|
574 | ||
|
0
Feb 24
|
1200 |
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
avoiding duplicates on uncommitted changes requires a bit of work. you should add onchange event to m2o fields which sets domain for these fields on selection. here your problem will be save vs save&new button. you might have to disable save&new button.
@Bréndou Serge Eric: I'm using your idea too. But it not really convenient for user when number of line become larger. So I want to find a way to limited allowance just show which haven't existed
@F.P.: I tried make a domain both in python code and view but neither work
@Leo, can you show us the code for the domains you have tried ?
I defined an onchange function on job.allowance.rel model:
@api.onchange('job_id')
def _onchange_job(self):
ids = self.job_id.allowance_ids.mapped('allowance_id').ids
return {
'domain': {
'allowance_id': [('id', 'not in', ids)],
},
}