Zum Inhalt springen
Sie müssen registriert sein, um mit der Community zu interagieren.
Alle Beiträge Personen Abzeichen
Stichwörter (Alle anzeigen)
odoo accounting v14 pos v15
Über dieses Forum
Diese Frage wurde gekennzeichnet
portalexecutesqlcontrollercr
2 Antworten
5373 Ansichten
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
Verwerfen
Avatar
Khubab Shams
Beste Antwort

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


Avatar
Verwerfen
Arian Shariat
Autor

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

Avatar
Ray Carnes (ray)
Beste Antwort

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
Verwerfen
Verknüpfte Beiträge Antworten Ansichten Aktivität
How to execute sql query on website controller? Gelöst
many2many query execute sql controller
Avatar
Avatar
3
Mai 20
12789
Error in sql while using operator "in" and variable Gelöst
function execute sql syntax
Avatar
Avatar
3
Okt. 15
6586
is possible to add 2 filters to the web portal similar to searchbar_filters?
portal
Avatar
Avatar
Avatar
2
Juli 25
1469
How can I allow one portal user to see another portal user's information (like Sales Orders, Invoices)? Gelöst
portal
Avatar
Avatar
1
Mai 24
2745
Use worksheets in Odoo Portal
portal
Avatar
Avatar
2
Feb. 24
2232