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

CRM
e-Commerce
Kirjanpito
Varastointi
PoS
Projekti
MRP

All apps

Kaikki kirjoitukset Ihmiset Merkit

Tunnisteet (Näytä kaikki)

odoo accounting v14 pos v15

Tietoa tästä foorumista

Apua

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

many2one one2many onchange domain_filter

2 Vastaukset

12711 Näkymät

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

Tekijä

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

Tekijä

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

Tekijä Paras vastaus

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

Tekijä

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

Nautitko keskustelusta? Älä vain lue, vaan osallistu!

Luo tili jo tänään nauttiaksesi yksinoikeusominaisuuksista ja osallistuaksesi mahtavaan yhteisöömme!

Rekisteröidy

Aiheeseen liittyviä artikkeleita	Vastaukset	Näkymät
How do I put One2many after Many2one defined? - transient module states reset many2one one2many	1 maalisk. 23	3231
Odoo Studio how to set a chain of multiple and related Many2one within a One2many lines many2one one2many	0 jouluk. 22	3836
odoo onchange function on one2many field Ratkaistu function fields many2one one2many onchange	3 lokak. 22	22305
filter according to comodel's fields many2one one2many	0 kesäk. 21	3525
How to update two levels o2m fileds relation one2many onchange	0 syysk. 20	3742

Tämä kysymys on merkitty

Nautitko keskustelusta? Älä vain lue, vaan osallistu!