Odoo Help


Is a join of filters by AND possible?

Peter Nietz
on 3/11/15, 11:47 AM 871 views

Hi folks,

when I define filters in my xml view like:

          <filter name="group_latest" string="Latest" domain="[('date', '>=', time.strftime('%Y-%m-%d'))]"/>
          <filter name="lat_north" string="Nördl. Hem" domain="[('geoip_latitude', '>=', 0)]"/>

and I use them both in my view they are joined by OR. But I want them to be exclusive, joined by AND so first filter is applied AND ALSO the second filter is applied on the results of the first filter.

Is this possible?

Emanuel Cino
On 3/11/15, 12:31 PM

You could create one other filter this way :

    <filter name="group_latest_north" string="Latest Nördl. Hem" domain="[('date', '>=', time.strftime('%Y-%m-%d')), ('geoip_latitude', '>=', 0)]"/>

Which will apply the AND condition.

that's not what I need. It will increase the complexity to much, cause there are lot more filters implemented and to implement all the combinations of joins (for more than 3 at a time) is not wanted. but thx anyway

Peter Nietz
on 3/12/15, 8:13 AM

Ok sorry. I don't think we can bind predefined filters with AND condition.

Emanuel Cino
on 3/13/15, 1:51 AM

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

1 follower(s)


Asked: 3/11/15, 11:47 AM
Seen: 871 times
Last updated: 3/16/15, 8:10 AM