Odoo Help


Order of precedence in search for data xml-files

Anders Wallenquist
on 1/15/16, 6:08 AM 598 views

I want to set account_debit to '5848' if there is one, otherwise set the account to '5800'

<record id="hr_salary_rule-sau" model="hr.salary.rule">
    <field name="account_debit" search="['|',('code', '=', '5848'),('code', '=', '5800')]" />

But i think the Postgres optimizer uses the order of code in account.account rather than care about the order of precedence.

Is there a way to do this? Change the order by? Conditions in the XML?

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

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: 1/15/16, 6:08 AM
Seen: 598 times
Last updated: 1/15/16, 6:08 AM