Skip to Content
You need to be registered to interact with the community.
All Posts People Badges
Ključne besede (View all)
odoo accounting v14 pos v15
About this forum
This question has been flagged
many2oneone2manyonchangedomain_filter
2 Odgovori
12685 Prikazi
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
Opusti
Leon
Avtor

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
Avtor

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
Avtor 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
Opusti
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
Opusti
Leon
Avtor

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

Related Posts Odgovori Prikazi Aktivnost
How do I put One2many after Many2one defined? - transient module states reset
many2one one2many
Avatar
1
mar. 23
3212
Odoo Studio how to set a chain of multiple and related Many2one within a One2many lines
many2one one2many
Avatar
0
dec. 22
3810
odoo onchange function on one2many field Solved
function fields many2one one2many onchange
Avatar
Avatar
Avatar
Avatar
3
okt. 22
22285
filter according to comodel's fields
many2one one2many
Avatar
0
jun. 21
3516
How to update two levels o2m fileds relation
one2many onchange
Avatar
0
sep. 20
3728