Cédric KrierSep 23, 2024
I cannot believe #Odoo is still using a polish notation for its domains
https://www.odoo.com/documentation/17.0/developer/reference/backend/orm.html#search-domains
ORM API — Odoo 17.0 documentation

Show threadJared KipeSep 27, 2024
@cedrickrier did I miss where there is an as elegant solution that would justify the deprecation?
Show threadCédric Krier
@jaredkipe parenthesis
Sep 27, 2024 at 10:08pmWeb
Show threadJared KipeOct 2, 2024
@cedrickrier ah I see which part you’re going after. I see a lot of advantages to merely being list of things.
I also find it rare to find domains that need more than a handful of (implicit) &s or a single |
Show threadCédric KrierOct 2, 2024
@jaredkipe Polish notation is easy to parse for machine (and I can tell you this is why it was chosen because I was there) but not for human.
Once we had introduced parenthesis in#Tryton, Or-ed expressions started to be use very often. To the point that we have an SQL optimization for search queries: https://bugs.tryton.org/10658
Using indexes in queries where the filter is made of 'OR'-ed expressions is suboptimal (#10658) · Issues · Tryton / Tryton · GitLab

We noticed that domains of the kind ['OR, ('a', '=', x), ('b.f1', '=', y)] that result in an expression of the kind t.a = x OR...

GitLab
Show threadJared KipeOct 2, 2024
@cedrickrier I am interested in this lore, want to get some dinner or fries in Brussels in the next couple of days?
Show threadCédric KrierOct 2, 2024
@jaredkipe I'm not in Brussels
Show threadJared KipeOct 2, 2024
@cedrickrier of course… well if you’re ever in the Seattle area, let me know!