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
| 関連投稿 | 返信 | ビュー | 活動 | |
|---|---|---|---|---|
|
3
3月 25
|
28789 | ||
|
2
3月 16
|
30614 | ||
|
0
2月 19
|
4776 | ||
|
3
7月 25
|
6064 | ||
|
0
5月 25
|
1670 |
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)],
},
}