Skip to Content
This question has been flagged
domain_filterOdoo12.0
3 Replies
3898 Views
Avatar
gain charlie

Hi,

My domain is conditional. How do i join them base on criteria below:

The function is to get ids from a table.

@api.onchange('month','year','department_ids','job_ids', 'date_from', 'date_to')

 def onchange_data_criteria(self):

        print('-----start processing payslip id from criteria-------')

        slip_ids = []

        domain = []


        if self.month and self.year:

            domain = domain + [('year', '=', self.year),('month', '=', self.month)]


        if self.job_ids:

            domain = domain + [('job_id', 'in', self.job_ids)]

        

        if self.date_from and self.date_to:

            domain = domain + [('date_from', '>=', self.date_from), ('date_from', '<=', self.date_to)]


        payslip = self.env['hr.payslip'].search(domain).id


I got the following error:

  File "/opt/odoo12/odoo/odoo/models.py", line 5308, in process
    if res.get('value'):
AttributeError: 'hr.payslip' object has no attribute 'get'


    

Avatar
Discard
Avatar
Ashish Singh
Best Answer

Hi, Gain

Instead of searching you need to return domain with this method like below,

@api.onchange('month','year','department_ids','job_ids', 'date_from', 'date_to')
def onchange_data_criteria(self):
    print('-----start processing payslip id from criteria-------')
    slip_ids = []
    domain = []
    if self.month and self.year:
        domain = domain + [('year', '=', self.year),('month', '=', self.month)]
    if self.job_ids:
        domain = domain + [('job_id', 'in', self.job_ids)]
    if self.date_from and self.date_to:
        domain = domain + [('date_from', '>=', self.date_from), ('date_from', '<=', self.date_to)]
    res = {}
    if domain:
        res['domain'] = domain
    return res
Feel free to ask in case you still have the same query.

Thanks,
Ashish Singh (Team Lead)
Webkul Software Private Limited
Avatar
Discard
Avatar
Vishnu Vanneri
Best Answer

Try to append like this


@api.onchange('month','year','department_ids','job_ids', 'date_from', 'date_to')

 def onchange_data_criteria(self):

        print('-----start processing payslip id from criteria-------')

        slip_ids = []

        domain = []


        if self.month and self.year:

            domain.append(('year', '=', self.year))

            domain.append(('month', '=', self.month))


        if self.job_ids:

            domain.append(('job_id', 'in', self.job_ids))

        

        if self.date_from and self.date_to:

            domain.append(('date_from', '>=', self.date_from)

            domain.append(('date_from', '<=', self.date_to))


        payslip = self.env['hr.payslip'].search(domain).id

Avatar
Discard
Related Posts Replies Views Activity
Dynamic Domain for states
domain_filter
Avatar
Avatar
1
May 24
1310
How to Limit Pos Category in Odoo 12 Shop?
Odoo12.0
Avatar
0
Mar 24
275
Odoo v16 domain, how to create a domain by user.company_id
domain_filter
Avatar
Avatar
1
Nov 22
3301
Why is the product_id initiated by default_product_id is NOT available during saving.
Odoo12.0
Avatar
0
Oct 22
1518
compare the lines in one2many fields
Odoo12.0
Avatar
0
Sep 22
664