Skip to Content
This question has been flagged
portalexecutesqlcontrollercr
2 Replies
4264 Views
Avatar
Arian Shariat

I want to use sql queries in CustomerPortal class controllers. I wrote following code:

request.cr.execute("""my query""")
result = request.cr.fetchall()
but I get the following error:
AttributeError: 'CustomerPortal (extended by PortalAccount, Custome' object has no attribute 'cr'a
what should I do?
Avatar
Discard
Avatar
Khubab Shams
Best Answer

Hello Arian, try to use 'request.session.cr' instead of 'request.cr'.


Avatar
Discard
Arian Shariat
Author

thanks! request.env.cr worked for me aswell.

Avatar
Ray Carnes (ray)
Best Answer

https://github.com/odoo/odoo/blob/13.0/addons/web/controllers/main.py#L1551

## inside try

registry = odoo.modules.registry.Registry(dbname)
with registry.cursor() as cr:
    cr.execute(""" query """)
    row = cr.fetchone()
Avatar
Discard
Related Posts Replies Views Activity
How to execute sql query on website controller? Solved
many2many query execute sql controller
Avatar
Avatar
3
May 20
11491
Error in sql while using operator "in" and variable Solved
function execute sql syntax
Avatar
Avatar
3
Oct 15
5454
How can I allow one portal user to see another portal user's information (like Sales Orders, Invoices)? Solved
portal
Avatar
Avatar
1
May 24
688
Use worksheets in Odoo Portal
portal
Avatar
Avatar
2
Feb 24
645
is possible to add 2 filters to the web portal similar to searchbar_filters?
portal
Avatar
0
Dec 23
315