Odoov13 how to use cr.execute in a controller?

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
Contabilitate
Inventar
PoS
Project
MRP

All apps

All Posts Oameni Insigne

Etichete (View all)

odoo accounting v14 pos v15

Despre acest forum

Suport

Odoov13 how to use cr.execute in a controller?

portal execute sql controller cr

2 Răspunsuri

5310 Vizualizări

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?

Khubab Shams

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

Arian Shariat

Autor

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

Ray Carnes (ray)

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()

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Înscrie-te

Related Posts	Răspunsuri	Vizualizări
How to execute sql query on website controller? Rezolvat many2many query execute sql controller	3 mai 20	12730
Error in sql while using operator "in" and variable Rezolvat function execute sql syntax	3 oct. 15	6529
is possible to add 2 filters to the web portal similar to searchbar_filters? portal	2 iul. 25	1393
How can I allow one portal user to see another portal user's information (like Sales Orders, Invoices)? Rezolvat portal	1 mai 24	2668
Use worksheets in Odoo Portal portal	2 feb. 24	2175

Această întrebare a fost marcată

Enjoying the discussion? Don't just read, join in!