Skip to Content
This question has been flagged
many2oneone2manyonchangedomain_filter
2 Replies
9874 Views
Avatar
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!



Avatar
Discard
Leon
Author

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
Author

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.

Avatar
Leon
Author Best Answer

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. 

Avatar
Discard
Avatar
Begineer
Best Answer

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

Avatar
Discard
Leon
Author

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

Related Posts Replies Views Activity
How do I put One2many after Many2one defined? - transient module states reset
many2one one2many
Avatar
1
Mar 23
783
Odoo Studio how to set a chain of multiple and related Many2one within a One2many lines
many2one one2many
Avatar
0
Dec 22
1507
odoo onchange function on one2many field Solved
function fields many2one one2many onchange
Avatar
Avatar
Avatar
Avatar
3
Oct 22
19461
filter according to comodel's fields
many2one one2many
Avatar
0
Jun 21
1838
How to update two levels o2m fileds relation
one2many onchange
Avatar
0
Sep 20
1736