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

CRM
e-Commerce
Boekhouding
Voorraad
PoS
Project
MRP

All apps

Alle posts Personen Badges

Labels (Bekijk alle)

odoo accounting v14 pos v15

Over dit forum

Help

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

many2one one2many onchange domain_filter

2 Antwoorden

12770 Weergaven

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

Auteur

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

Auteur

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

Auteur Beste antwoord

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

Auteur

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

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!

Maak vandaag nog een account aan om te profiteren van exclusieve functies en deel uit te maken van onze geweldige community!

Aanmelden

Gerelateerde posts	Antwoorden	Weergaven
How do I put One2many after Many2one defined? - transient module states reset many2one one2many	1 mrt. 23	3300
Odoo Studio how to set a chain of multiple and related Many2one within a One2many lines many2one one2many	0 dec. 22	3906
odoo onchange function on one2many field Opgelost function fields many2one one2many onchange	3 okt. 22	22378
filter according to comodel's fields many2one one2many	0 jun. 21	3562
How to update two levels o2m fileds relation one2many onchange	0 sep. 20	3812

Deze vraag is gerapporteerd

Geniet je van het gesprek? Blijf niet alleen lezen, doe ook mee!