Skip ke Konten
Pertanyaan ini telah diberikan tanda
portalexecutesqlcontrollercr
2 Replies
5304 Tampilan
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
Buang
Avatar
Khubab Shams
Jawaban Terbai

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


Avatar
Buang
Arian Shariat
Penulis

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

Avatar
Ray Carnes (ray)
Jawaban Terbai

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
Buang
Post Terkait Replies Tampilan Aktivitas
How to execute sql query on website controller? Diselesaikan
many2many query execute sql controller
Avatar
Avatar
3
Mei 20
12730
Error in sql while using operator "in" and variable Diselesaikan
function execute sql syntax
Avatar
Avatar
3
Okt 15
6529
is possible to add 2 filters to the web portal similar to searchbar_filters?
portal
Avatar
Avatar
Avatar
2
Jul 25
1392
How can I allow one portal user to see another portal user's information (like Sales Orders, Invoices)? Diselesaikan
portal
Avatar
Avatar
1
Mei 24
2664
Use worksheets in Odoo Portal
portal
Avatar
Avatar
2
Feb 24
2174