I was creating the report i unable to trace the error that I got.
Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
- CRM
- e-Commerce
- Contabilidad
- Inventario
- PoS
- Proyectos
- MRP
Se marcó esta pregunta
1
Responder
5294
Vistas
Hi,
Please try by setting _auto = False for your model
example:
class PosOrderReport(models.Model):
_name = "report.pos.order"
_description = "Point of Sale Orders Report"
_auto = False
_order = 'date desc'
For more details refer this video:Create Model/DB View Using Query In Odoo || Combine Multiple Model Into One Model
Hope this will help you
Thank you
¿Le interesa esta conversación? ¡Participe en ella!
Cree una cuenta para poder utilizar funciones exclusivas e interactuar con la comunidad.
Registrarse| Publicaciones relacionadas | Respuestas | Vistas | Actividad | |
|---|---|---|---|---|
|
2
dic 23
|
3940 | ||
|
1
oct 23
|
8533 | ||
|
0
abr 23
|
2255 | ||
|
Override report_invoice_document
Resuelto
|
|
1
mar 23
|
4615 | |
|
Studio : bank details on Invoice
Resuelto
|
|
1
ene 23
|
3551 |
2022-09-15 07:45:25,499 44731 ERROR demo05.3 odoo.sql_db: bad query: DROP view IF EXISTS asset_asset_report CASCADE
ERROR: "asset_asset_report" is not a view
HINT: Use DROP TABLE to remove a table.
2022-09-15 07:45:25,500 44731 WARNING demo05.3 odoo.modules.loading: Transient module states were reset
2022-09-15 07:45:25,500 44731 ERROR demo05.3 odoo.modules.registry: Failed to load registry
2022-09-15 07:45:25,500 44731 CRITICAL demo05.3 odoo.service.server: Failed to initialize database `demo05.3`.
Traceback (most recent call last):
File "/home/ashutosh/Desktop/Reckonsys/Asset-management/asset-management/odoo/odoo/service/server.py", line 1260, in preload_registries
registry = Registry.new(dbname, update_module=update_module)
File "/home/ashutosh/Desktop/Reckonsys/Asset-management/asset-management/odoo/odoo/modules/registry.py", line 87, in new
odoo.modules.load_modules(registry, force_demo, status, update_module)
File "/home/ashutosh/Desktop/Reckonsys/Asset-management/asset-management/odoo/odoo/modules/loading.py", line 470, in load_modules
processed_modules += load_marked_modules(cr, graph,
File "/home/ashutosh/Desktop/Reckonsys/Asset-management/asset-management/odoo/odoo/modules/loading.py", line 363, in load_marked_modules
loaded, processed = load_module_graph(
File "/home/ashutosh/Desktop/Reckonsys/Asset-management/asset-management/odoo/odoo/modules/loading.py", line 199, in load_module_graph
registry.init_models(cr, model_names, {'module': package.name}, new_install)
File "/home/ashutosh/Desktop/Reckonsys/Asset-management/asset-management/odoo/odoo/modules/registry.py", line 428, in init_models
model.init()
File "/home/ashutosh/Desktop/Reckonsys/Asset-management/asset-management/custome_addon/asset-management/models/models.py", line 185, in init
tools.drop_view_if_exists(self._cr, self._table)
File "/home/ashutosh/Desktop/Reckonsys/Asset-management/asset-management/odoo/odoo/tools/sql.py", line 245, in drop_view_if_exists
cr.execute("DROP view IF EXISTS %s CASCADE" % (viewname,))
File "<decorator-gen-3>", line 2, in execute
File "/home/ashutosh/Desktop/Reckonsys/Asset-management/asset-management/odoo/odoo/sql_db.py", line 89, in check
return f(self, *args, **kwargs)
File "/home/ashutosh/Desktop/Reckonsys/Asset-management/asset-management/odoo/odoo/sql_db.py", line 310, in execute
res = self._obj.execute(query, params)
psycopg2.errors.WrongObjectType: "asset_asset_report" is not a view
HINT: Use DROP TABLE to remove a table.