How to compare fields in a filter ?

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

CRM
e-Commerce
Księgowość
Zapasy
PoS
Project
MRP

All apps

Wszystkie posty Osoby Odznaki

Tagi (Zobacz wszystko)

odoo accounting v14 pos v15

O tym forum

Pomoc

How to compare fields in a filter ?

domain_filter filters

2 Odpowiedzi

15942 Widoki

Mohamed Hagag

Dears,

Plz let me know how to make this filter work, adding filter on partners search form:

<filter name="credit limit" domain="[('credit','>',credit_limit)]"/>

Applying this filter gives below error:

Uncaught Error: Failed to evaluate search criterions:
{"code":400,"message":"Evaluation Error","data":{"type":"local_exception","debug":"Local evaluation failure\nNameError: name 'credit_limit' is not defined\n\n{\"domains\":[[],\"[('customer','=',1)]\",\"[('credit','=',credit_limit)]\"],\"contexts\":[{\"lang\":\"en_US\",\"tz\":\"Africa/Cairo\",\"uid\":1,\"search_default_customer\":1}],\"group_by_seq\":[]}"}}

I googled many times to find a solution without finding anyone .

the simple form [('credit_limit','<',credit)] always returns the error "can not convert string to float" where string is credit and float is credit_limit.

is there any way to say [('credit_limit','<',valueof(credit))] or [('field1','=',valueof(field2))] ??

Regards,

Pascal Tremblay

I have the error today!

Cyril Gaspard (GEM)

Najlepsza odpowiedź

Hi,

simply create a stored boolean function field, which depends of the 2 fields you want to compare, test the operation you need in function, you can now filter by the boolean value.

using last api

in your python file

from odoo import api, fields, models

class ResPartner(models.Model):
    _inherit = 'res.partner'

    credit = fields.Float(string="Credit")
    credit_limit = fields.Float(string="Credit limit")
    is_credit_limit_exceeded = fields.Boolean(compute='_get_is_credit_limit_exceeded',
                                              string="Credit limit exceeded",
                                              compute_sudo=True, store=True)

    @api.multi
    @api.depends('credit', 'credit_limit')
    def _get_is_credit_limit_exceeded(self):
        self.is_credit_limit_exceeded = self.credit > self.credit_limit

in your xml file, in search view

<filter name="Credit limit" domain="[('is_credit_limit_exceeded', '=', True)]"/>

Ibrahim Boudmir

Without forgetting to add the boolean field with invisible="1"

Cyril Gaspard (GEM)

Hi,

this is a stored field function with dependecies, no need to add the field in view.

Bye

Podoba Ci się ta dyskusja? Dołącz do niej!

Stwórz konto dzisiaj, aby cieszyć się ekskluzywnymi funkcjami i wchodzić w interakcje z naszą wspaniałą społecznością!

Zarejestruj się

Powiązane posty	Odpowiedzi	Widoki
Dynamic Domain for states domain_filter	1 maj 24	2727
Sales by week # custom filter filters	0 lis 23	1181
How do I delete a saved filter? Rozwiązane filters	2 cze 23	11769
Odoo v16 domain, how to create a domain by user.company_id domain_filter	1 lis 22	5056
Filtering domain domain_filter	2 lip 22	3792

To pytanie dostało ostrzeżenie

Podoba Ci się ta dyskusja? Dołącz do niej!