Odoo Help


This community 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.


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

on 2/21/15, 11:26 PM 705 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.



| 5 4 7
Bengaluru, India

Techno-Functional Associate with 6+ 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...

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 community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)


Asked: 2/21/15, 11:26 PM
Seen: 705 times
Last updated: 6/26/15, 8:25 AM