Odoo Help


Can I run a recursive query statement using cr.execute?

on 2/21/15, 11:26 PM 1,191 views

Hi folks,

I have a recursive query using the statement WITH RECURSIVE, also called (Common Table Expressions). I tested it inside the pgAdmin and it runs OK, but I can't make it work from inside OpenERP using cr.execute(query). Any ideas? 

On 6/26/15, 8:25 AM

Thanks so much for your time. I could do it at the end. I wrapped my query using '''...''', then it worked.


Techno-Functional Associate with 7+ years of experience in Odoo (formerly known as OpenERP).

On 2/23/15, 8:58 AM

If it is working fine in Pgadmin, then definetly it will work in Cr.execute... guess something you would have missed, may be parameter or so, have a look at it.. or do paste your code for better picture...

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: 2/21/15, 11:26 PM
Seen: 1191 times
Last updated: 6/26/15, 8:25 AM