Intro/context
Working on the "RFQ2+3" of the OCA about membership process automation and new OCA website, I'll submit here as Github issues the various optimizations I discover possible on the OCA database / modules.
This is to review them in collective or discuss about them.
So this is is a 1st one but I think a few other will follow.
Good think is I can deep-dive/test/confirm a few things in a daily test environment used for Akretion devs, like this one is already tested and seems easy to go with.
Issue description
The useful module is bi_sql_editor, the other sql_request_abstract is a dependency to remove also.
What the module does:
It enables custom view in "Dashboard", generated from raw SQL in Odoo.
Currently 1 custom view is here, but is broken.
The SQL view seems to have been written in 2018 and is about Github module, which has greatly moved since.
Possible active users of the SQL report:
Steps to solve
env.execute(f"""
DROP TABLE IF EXISTS x_bi_sql_view_module_version_creation_date;
""")
env['ir.module.module'].search([('name', '=', 'sql_request_abstract')]).button_immediate_uninstall()
Intro/context
Working on the "RFQ2+3" of the OCA about membership process automation and new OCA website, I'll submit here as Github issues the various optimizations I discover possible on the OCA database / modules.
This is to review them in collective or discuss about them.
So this is is a 1st one but I think a few other will follow.
Good think is I can deep-dive/test/confirm a few things in a daily test environment used for Akretion devs, like this one is already tested and seems easy to go with.
Issue description
The useful module is
bi_sql_editor, the othersql_request_abstractis a dependency to remove also.What the module does:
It enables custom view in "Dashboard", generated from raw SQL in Odoo.
Currently 1 custom view is here, but is broken.
The SQL view seems to have been written in 2018 and is about Github module, which has greatly moved since.
Possible active users of the SQL report:
Steps to solve