bi_sql_editor
in reporting-engine · source on GitHub
BI Views builder, based on Materialized or Normal SQL Views
Category: Reporting · GRAP · AGPL-3
| Series | Status | Details | Code |
|---|---|---|---|
| 16.0 | ✓Installs | · run 2026-08-21 · 16.0.2.0.2 | on GitHub |
| 17.0 | ✓Installs | · run 2026-08-21 · 17.0.2.1.1 | on GitHub |
| 18.0 | ✓Installs | · run 2026-08-20 · 18.0.1.0.4 | on GitHub |
| 19.0 | ✓Installs | · run 2026-08-19 · 19.0.2.0.1 | on GitHub |
| 20.0 | —Not tested | no branch |
Odoo 20.0 dev — development line
A different statement from the table above. There: the module as published, on a released platform. Here: the module’s code with its manifest version mechanically raised, on a platform that has not been released and changes daily.
| Status | Details |
|---|---|
| ✗fails | The same code installs on 19.0; on the development line it does not. The difference belongs to the platform. (model_gone) · failed in a file of ANOTHER module: sql_request_abstract/security/ir.model.access.csv · version 19.0.2.0.1 → 19.5.2.0.1, code unchanged · run 2026-09-11 · odoo 19.5 · modidx/odoo:master-deps-20260910 |
Log excerpt, 20.0 dev
2026-09-11 01:46:51,140 1 INFO job_ac7e08f2f7af odoo.modules.loading: loading sql_request_abstract/security/ir_module_category.xml
2026-09-11 01:46:51,170 1 INFO job_ac7e08f2f7af odoo.modules.loading: loading sql_request_abstract/security/res_groups.xml
2026-09-11 01:46:51,387 1 INFO job_ac7e08f2f7af odoo.modules.loading: loading sql_request_abstract/security/ir.model.access.csv
2026-09-11 01:46:51,508 1 WARNING job_ac7e08f2f7af odoo.modules.loading: Transient module states were reset
2026-09-11 01:46:51,509 1 ERROR job_ac7e08f2f7af odoo.registry: Failed to load registry
2026-09-11 01:46:51,509 1 CRITICAL job_ac7e08f2f7af odoo.service.server: Failed to initialize database `job_ac7e08f2f7af`.
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/odoo/service/server.py", line 1559, in preload_registries
registry = Registry.new(dbname, update_module=update_module, install_modules=config['init'], upgrade_modules=config['update'], reinit_modules=config['reinit'])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/tools/func.py", line 67, in locked
return func(inst, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/orm/registry.py", line 222, in new
contextvars.Context().run(
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 446, in load_modules
load_module_graph(
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 211, in load_module_graph
load_data(env, idref, 'init', kind='data', package=package)
File "/usr/lib/python3/dist-packages/odoo/modules/loading.py", line 56, in load_data
convert_file(env, package.name, filename, idref, mode, noupdate=kind == 'demo')
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 712, in convert_file
convert_csv_import(env, module, pathname, fp.read(), idref, mode, noupdate)
File "/usr/lib/python3/dist-packages/odoo/tools/convert.py", line 769, in convert_csv_import
result = env[model].with_context(**context).load(fields, datas)
~~~^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/orm/environments.py", line 107, in __getitem__
return self.registry[model_name](self, (), ())
~~~~~~~~~~~~~^^^^^^^^^^^^
File "/usr/lib/python3/dist-packages/odoo/orm/registry.py", line 385, in __getitem__
return self.models[model_name]
~~~~~~~~~~~^^^^^^^^^^^^
KeyError: 'ir.model.access'
2026-09-11 01:46:51,514 1 INFO job_ac7e08f2f7af odoo.service.server.ThreadedServer: Initiating shutdown
2026-09-11 01:46:51,515 1 INFO job_ac7e08f2f7af odoo.service.server.ThreadedServer: Hit CTRL-C again or send a second signal to force the shutdown.
2026-09-11 01:46:51,515 1 INFO job_ac7e08f2f7af odoo.addons.bus.websocket: Disconnecting 0 websockets
2026-09-11 01:46:51,617 1 INFO job_ac7e08f2f7af odoo.sql_db: ConnectionPool(read/write;used=0/count=0/max=64): Closed 1 connectionsProvenance: __manifest__.py sha256 0d18fe3efaae7cef… · tree of 96 files without the manifest, sha256 702fc2c948a833e6…
This does not say the module is compatible with Odoo 20.0, and does not say it installs on Odoo 20.0 — on a stock platform it will not, until its maintainer raises the version. Why we raise the version
Odoo 20.0 — the branch itself
The same frozen code, run again against the real 20.0 branch. The run above used Odoo’s development line before the branch was cut; this one used the branch, pinned to one commit.
| Status | Details |
|---|---|
| ✗fails | The same code installs on 19.0; on the development line it does not. The difference belongs to the platform. (model_gone) · failed in a file of ANOTHER module: sql_request_abstract/security/ir.model.access.csv · version 19.0.2.0.1 → 20.0.2.0.1, code unchanged · run 2026-09-18 · odoo 20.0 · modidx/odoo:20.0-deps-20260918 |
Log excerpt, 20.0 dev
2026-09-18 23:17:36,694 1 INFO job_3dda70b46a70 odoo.modules.loading: loading sql_request_abstract/security/ir_module_category.xml
2026-09-18 23:17:36,719 1 INFO job_3dda70b46a70 odoo.modules.loading: loading sql_request_abstract/security/res_groups.xml
2026-09-18 23:17:36,950 1 INFO job_3dda70b46a70 odoo.modules.loading: loading sql_request_abstract/security/ir.model.access.csv
2026-09-18 23:17:37,059 1 WARNING job_3dda70b46a70 odoo.modules.loading: Transient module states were reset
2026-09-18 23:17:37,060 1 ERROR job_3dda70b46a70 odoo.registry: Failed to load registry
2026-09-18 23:17:37,060 1 CRITICAL job_3dda70b46a70 odoo.service.server: Failed to initialize database `job_3dda70b46a70`.
Traceback (most recent call last):
File "/opt/odoo/odoo/service/server.py", line 1520, in preload_registries
registry = Registry.new(dbname, update_module=update_module, install_modules=config['init'], upgrade_modules=config['update'], reinit_modules=config['reinit'])
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/odoo/tools/func.py", line 67, in locked
return func(inst, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/opt/odoo/odoo/orm/registry.py", line 222, in new
contextvars.Context().run(
File "/opt/odoo/odoo/modules/loading.py", line 449, in load_modules
load_module_graph(
File "/opt/odoo/odoo/modules/loading.py", line 211, in load_module_graph
load_data(env, idref, 'init', kind='data', package=package)
File "/opt/odoo/odoo/modules/loading.py", line 56, in load_data
convert_file(env, package.name, filename, idref, mode, noupdate=kind == 'demo')
File "/opt/odoo/odoo/tools/convert.py", line 714, in convert_file
convert_csv_import(env, module, pathname, fp.read(), idref, mode, noupdate)
File "/opt/odoo/odoo/tools/convert.py", line 771, in convert_csv_import
result = env[model].with_context(**context).load(fields, datas)
~~~^^^^^^^
File "/opt/odoo/odoo/orm/environments.py", line 107, in __getitem__
return self.registry[model_name](self, (), ())
~~~~~~~~~~~~~^^^^^^^^^^^^
File "/opt/odoo/odoo/orm/registry.py", line 385, in __getitem__
return self.models[model_name]
~~~~~~~~~~~^^^^^^^^^^^^
KeyError: 'ir.model.access'
2026-09-18 23:17:37,063 1 INFO job_3dda70b46a70 odoo.service.server.ThreadedServer: Initiating shutdown
2026-09-18 23:17:37,063 1 INFO job_3dda70b46a70 odoo.service.server.ThreadedServer: Hit CTRL-C again or send a second signal to force the shutdown.
2026-09-18 23:17:37,063 1 INFO job_3dda70b46a70 odoo.addons.bus.websocket: Disconnecting 0 websockets
2026-09-18 23:17:37,164 1 INFO job_3dda70b46a70 odoo.sql_db: ConnectionPool(read/write;used=0/count=0/max=64): Closed 1 connectionsProvenance: __manifest__.py sha256 0d18fe3efaae7cef… · tree of 96 files without the manifest, sha256 702fc2c948a833e6…
This does not say the module is compatible with Odoo 20.0, and does not say it installs on Odoo 20.0 — on a stock platform it will not, until its maintainer raises the version. Why we raise the version
The module’s code on 19.0
| Lines of code | python 1 278 · xml 337 |
| Tests | yes: 1 file(s), 141 lines |
| Migration scripts | yes: 19.0.2.0.0 |
| Models | 2 new · 2 extensions |
| Raw SQL | 2 × cr.execute |
Lines are physical, blanks and comments included, as wc -l. Tests are test_*.py files under tests/. Models are lines holding _name = and _inherit =. These are facts about the code, not a judgement: more lines is neither better nor worse. Measured 2026-08-28 on tree 951ae965af7a.
The apps.odoo.com catalogue has a listing under the same technical name on 16.0, 17.0, 18.0, 19.0: apps.odoo.com/apps/modules/19.0/bi_sql_editor. A matching name does not prove matching code — how we counted this.
Depends on
| Module | Status | Checked |
|---|---|---|
| spreadsheet_dashboard | core | ships with Odoo |
| sql_request_abstract | ✓Installs | 2026-08-19 |
History
| Last change | 2026-07-29 |
| Code commits, 12 months | 66 |
| Most active | Sylvain LE GAL, mreficent, hveficent |
| Files | 97 |
Translation and bot commits are excluded from the commit count.
Result looks wrong? Tell us — we will show the log or run it again. Report a wrong result