Odoo Help

0

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

By
jgonzalez
on 2/21/15, 11:26 PM 823 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? 

0
jgonzalez
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.

0

deep

--deep--
1688
| 5 5 7
Bengaluru, India
--deep--

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

deep
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.

Register

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)

Stats

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