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
- Akuntansi
- Inventaris
- PoS
- Project
- MRP
Pertanyaan ini telah diberikan tanda
1
Balas
5398
Tampilan
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
Menikmati diskusi? Jangan hanya membaca, ikuti!
Buat akun sekarang untuk menikmati fitur eksklufi dan agar terlibat dengan komunitas kami!
Daftar| Post Terkait | Replies | Tampilan | Aktivitas | |
|---|---|---|---|---|
|
2
Des 23
|
4059 | ||
|
1
Okt 23
|
8644 | ||
|
0
Apr 23
|
2322 | ||
|
Override report_invoice_document
Diselesaikan
|
|
1
Mar 23
|
4751 | |
|
Studio : bank details on Invoice
Diselesaikan
|
|
1
Jan 23
|
3627 |
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.