Skip to Content
This question has been flagged
filterNonetype
1 Reply
2181 Views
Avatar
Dagina

Hello everyone

I've created a custom selection field called payment_status which is not stored. I want to create filter for this without storing it. for this I've added the search function. my code is:

 payment_status = fields.Selection(        [            ("not_paid", "Not Paid"),            ("partially_paid", "Partially Paid"),            ("fully_paid", "Fully Paid"),        ],        compute="_computepaid", search="_search_payment_status"    )

 def _search_payment_status(self,operator, value):
	​if value not in ['not_paid', 'partially_paid', 'fully_paid']:
	​	​return [('id', 'in', [])]        
	​search_domain = [('payment_status', '=', value)]        
	​for rec in self:            
	​	​orders = rec.env['purchase.order'].search(search_domain)            
	​	​return [('id', 'in', orders.ids)]

but this is generating the following error:

Odoo Server Error
Traceback (most recent call last):
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 624, in _handle_exception
    return super(JsonRequest, self)._handle_exception(exception)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 310, in _handle_exception
    raise pycompat.reraise(type(exception), exception, sys.exc_info()[2])
  File "/usr/lib/python3/dist-packages/odoo/tools/pycompat.py", line 14, in reraise
    raise value
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 669, in dispatch
    result = self._call_function(**self.params)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 350, in _call_function
    return checked_call(self.db, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/service/model.py", line 94, in wrapper
    return f(dbname, *args, **kwargs)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 339, in checked_call
    result = self.endpoint(*a, **kw)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 915, in __call__
    return self.method(*args, **kw)
  File "/usr/lib/python3/dist-packages/odoo/http.py", line 515, in response_wrap
    response = f(*args, **kw)
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1300, in search_read
    return self.do_search_read(model, fields, offset, limit, domain, sort)
  File "/usr/lib/python3/dist-packages/odoo/addons/web/controllers/main.py", line 1319, in do_search_read
    return Model.web_search_read(domain, fields, offset=offset, limit=limit, order=sort)
  File "/usr/lib/python3/dist-packages/odoo/addons/web/models/models.py", line 48, in web_search_read
    records = self.search_read(domain, fields, offset=offset, limit=limit, order=order)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 4964, in search_read
    records = self.search(domain or [], offset=offset, limit=limit, order=order)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 1655, in search
    res = self._search(args, offset=offset, limit=limit, order=order, count=count)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 4506, in _search
    query = self._where_calc(args)
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 4226, in _where_calc
    e = expression.expression(domain, self)
  File "/usr/lib/python3/dist-packages/odoo/osv/expression.py", line 681, in __init__
    self.parse()
  File "/usr/lib/python3/dist-packages/odoo/osv/expression.py", line 948, in parse
    model._flush_search(domain, order='id')
  File "/usr/lib/python3/dist-packages/odoo/models.py", line 4422, in _flush_search
    domain = list(domain) + (self.env['ir.rule']._compute_domain(self._name, 'read') or [])
TypeError: 'NoneType' object is not iterable

I even tried to add conditions for None records but it doesn't work.
Can anyone please help me on this?




Avatar
Discard
Niyas Raphy (Walnut Software Solutions)

share the code of _computepaid function along with the post

Avatar
Cybrosys Techno Solutions Pvt.Ltd
Best Answer

Hi,

The error you're encountering seems to be related to the computation of the domain for searching records in your custom selection field payment_status. Let's refine your _search_payment_status method to avoid this error.
Here's an improved version of your _search_payment_status method:from odoo import api

class YourModel(models.Model):
    _name = 'your.model'

    payment_status = fields.Selection(
        [("not_paid", "Not Paid"),
         ("partially_paid", "Partially Paid"),
         ("fully_paid", "Fully Paid"),
        ], compute="_compute_payment_status", search="_search_payment_status"
    )

    @api.depends('related_field')  # Replace 'related_field' with the field that determines the payment status
    def _compute_payment_status(self):
        for record in self:
            # Your computation logic to determine payment status
            record.payment_status = 'not_paid'  # Example: set to 'not_paid' if condition not met

    def _search_payment_status(self, operator, value):
        if value not in ['not_paid', 'partially_paid', 'fully_paid']:
            return [('id', 'in', [])]  # Return an empty domain if value is not valid
        search_domain = [('payment_status', '=', value)]
        orders = self.env['purchase.order'].search(search_domain)
        return [('id', 'in', orders.ids)]


Hope it helps

Avatar
Discard
Related Posts Replies Views Activity
¿Cómo puedo contactar con el servicio de atención al cliente de Swiss Airlines?[Swiss Airlines teléfono España]
filter
Avatar
0
Dec 25
2
cbbbbggf
filter
Avatar
0
Nov 25
2
Factura en estado "EN PROCESO DE PAGO"
filter
Avatar
0
Nov 25
2
Simultaneous search criteria across companies and persons Solved
filter
Avatar
Avatar
1
Oct 25
847
Extended "shop" controller executes (confirmed by log), but the view ignores the modified "qcontext" (even with request.render)
filter
Avatar
Avatar
Avatar
3
Oct 25
1092