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
- Comptabilité
- Inventaire
- PoS
- Projet
- MRP
Cette question a été signalée
1
Répondre
5254
Vues
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
Vous appréciez la discussion ? Ne vous contentez pas de lire, rejoignez-nous !
Créez un compte dès aujourd'hui pour profiter de fonctionnalités exclusives et échanger avec notre formidable communauté !
S'inscrire| Publications associées | Réponses | Vues | Activité | |
|---|---|---|---|---|
|
2
déc. 23
|
3913 | ||
|
1
oct. 23
|
8469 | ||
|
0
avr. 23
|
2246 | ||
|
1
mars 23
|
4596 | ||
|
1
janv. 23
|
3531 |
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.