Skip to Content
Dette spørgsmål er blevet anmeldt
portalexecutesqlcontrollercr
2 Besvarelser
5375 Visninger
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
Kassér
Avatar
Khubab Shams
Bedste svar

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


Avatar
Kassér
Arian Shariat
Forfatter

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

Avatar
Ray Carnes (ray)
Bedste svar

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
Kassér
Related Posts Besvarelser Visninger Aktivitet
How to execute sql query on website controller? Løst
many2many query execute sql controller
Avatar
Avatar
3
maj 20
12793
Error in sql while using operator "in" and variable Løst
function execute sql syntax
Avatar
Avatar
3
okt. 15
6587
is possible to add 2 filters to the web portal similar to searchbar_filters?
portal
Avatar
Avatar
Avatar
2
jul. 25
1477
How can I allow one portal user to see another portal user's information (like Sales Orders, Invoices)? Løst
portal
Avatar
Avatar
1
maj 24
2751
Use worksheets in Odoo Portal
portal
Avatar
Avatar
2
feb. 24
2232