Odoo Help

Welcome!

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.

0

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

By
jgonzalez
on 2/21/15, 11:26 PM 742 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--
1617
| 5 4 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...

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)

Stats

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