Odoo Help


What PostgreSQL queries fire when a odoo external api functions runs?

Rohit Pandey
on 8/10/18, 6:27 AM 66 views
models.execute_kw(db, uid, password,
    'res.partner', 'search',
    [[['is_company', '=', True], ['customer', '=', True]]])

when these type of external command runs, a postgres command also runs behind then scene which evaluate the result.
I want to know what command run in postgres when a odoo api function runs.

Ray Carnes (ray)
On 8/10/18, 1:48 PM

Run Odoo with the startup parameter:

enables DEBUG logging of SQL querying

You can do this either on the command-line or via a Configuration File.





Sudhir Arya (ERP Harbor Consulting Services)

--Sudhir Arya (ERP Harbor Consulting Services)--
| 6 8 8
Ahmedabad, India
--Sudhir Arya (ERP Harbor Consulting Services)--

• Co-Founder & Co-Owner at ERP Harbor Consulting Services

• ERP Consultant / ERP Customization / TechnoFunctional Expert

• Sound knowledge in Python, Odoo (Open ERP), XML, PostgreSQL

• Domain knowledge of Sale Management, Purchase Management, Warehouse Management, Manufacturing, Multi Company Configuration & Management, HR Management, Medical Management, Construction Management, Education Management, Point of Sale, Third Party Integrations

• Positive attitude and quick Learner

• Good analytical skill, quick bug and issue tracing and find the solution

• Good knowledge and experience in payment gateway integration with Odoo

• Ready to accept new challenges

• Active Memeber On Stackoverflow 




Sudhir Arya
ERP Harbor Consulting Services
Sudhir Arya (ERP Harbor Consulting Services)
On 8/10/18, 8:21 AM

Hi Rohit,

Maybe _where_calc method can help you. Try to trace the code, put the print statements which will print the query for the domain.

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: 8/10/18, 6:27 AM
Seen: 66 times
Last updated: 8/10/18, 1:48 PM