Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Księgowość
Zapasy
PoS
Projekt
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

How to give Domain filter for one2many field base on the condition of another field? (Odoo 13)

many2one one2many onchange domain_filter

2 Odpowiedzi

12866 Widoki

Leon

Hello,

Im trying to set Domain filter for one2many field of 'model_b.py' when showing base on the condition of another field of 'model_c.py' .

model_a.py :

name = fields.Many2one('hr.employee')

keya = fields.Many2one('model.b')

num_a = fields.Monetary()

model_b.py :

name = fields.Many2one('hr.employee')

o_2_m = fields.One2many('model.a', 'keya')
get_value_c = fields.Many2one('model.c', string='Get value of C', required= True)

model_c.py :

_rec_name = "code_c"

code_c = fields.Char('Code', required= True)

num_c = fields.Monetary()

So, the condition is if field num_c is == num_a, then it will show all the related records which have num_a's values in o_2_m field by a popup when the user clicks on the "Add a line" link. If not, it will show nothing.

Im trying to create onchange function in model_b.py to execute like this:

@api.onchange('get_value_c')
def onchange_get_value_c(self):

for rec in self:

return {'domain': {'o_2_m': [('get_value_c','=', rec.get_value_c)]}}

But I don't know how to compare values of num_c and num_a for getting the results.

Please help!

Thank you!

Leon

Autor

Hi,

I'd tried with onchange in model_b.py like this:

@api.onchange('get_value_c')
 def onchange_get_value_c(self):
    for rec in self:
       if rec.get_value_c and rec.o_2_m:
          for line in rec.get_value_c:
             find_c = self.env["model.c"].search([('num_c', '=', line.num_c)])
             find_a = self.env["model.a"].search([('num_a', '=', line.num_a)])
             #compare value of num_c with num_a
             if find_c.num_c == find_a.num_a:
                 for abc in rec.o_2_m:
                    return {'domain': {'o_2_m': [('num_a','=', abc.find_a.id)]}}

But it still not works.

Begineer

Hi,

May i know how data is entered in one2many..??

Your onchange works only if you have data in get_value_c and o_2_m

Leon

Autor

Hi Karthikeyan,

The data already have in model_a.py . So the one2many field of model_b.py connected with many2one field in model_a.py. Then, when click on the "Add a line" link of one2many field, it will show all the already records of model_a.py. without filtering.

This means that, first, the data must be fill in model_a.py.

After that, when the user wants to filter the records which have relate value of num_a for selecting. Then they must be fill value in num_c. Of course, the scenario related to field 'num_c' will be built properly.

If the user don't want to filtering, then they don't need to select in many2one 'get_value_c', then when click on "Add a line" link. It will show all the records without filtering.

Niyas Raphy (Walnut Software Solutions)

Domain Based on Another field: https://www.youtube.com/watch?v=IpXXYCsK2ow

Leon

Autor Najlepsza odpowiedź

Finally, I'd solved my requirement.

Using onchange in model_b.py like this:

@api.onchange('get_value_c') 
def onchange_get_value_c(self): 
    for rec in self: 
        if rec.get_value_c:
            for line in rec.get_value_c: 
                find_c = self.env["model.c"].search([('num_c', '=', line.num_c)])
                
                if find_c:
                     return {'domain': {'o_2_m': [('num_a','=', find_c.num_c)]}}

And it works fine after the user selecting many2one 'get_value_c' which have the value in field 'num_c', then when click on the "Add a line" link, it will show all records which have value in field 'num_a' equal to the value in field 'num_c'.

If the user selecting many2one 'get_value_c' but not set the value for field 'num_c' or the value is not equal to the value in field 'num_a'. Then when clicking on the "Add a line" link, it will show nothing with raise information.

Begineer

Hi,

Here i think its not possible, why because,

1.You have a condition ( if field num_c is == num_a) and based on this you need to given domain to your one2many
2.But the field num_a itself is inside the one2many, without selecting num_a you cannot apply your domain.
3.Try changing your logic

Thanks

Leon

Autor

Hi Karthikeyan, thank you for your support. Yes, I'd selected num_a for a domain. Please view my answer in above.

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
How do I put One2many after Many2one defined? - transient module states reset many2one one2many	1 mar 23	3332
Odoo Studio how to set a chain of multiple and related Many2one within a One2many lines many2one one2many	0 gru 22	3980
odoo onchange function on one2many field Rozwiązane function fields many2one one2many onchange	3 paź 22	22446
filter according to comodel's fields many2one one2many	0 cze 21	3592
How to update two levels o2m fileds relation one2many onchange	0 wrz 20	3872

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!