Module: sql_export_mail - Odoo Module Metadata

TIP: You can type at any time to perform a new search.

SQL Export Mail

sql_export_mail

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/18.0/sql_export_mail
VERSION
VERSION	1.0.0
CATEGORY
CATEGORY	Generic Modules
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	OCA-git-bot, oca-ci, Lars Quaedvlieg
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 19:30:07
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/reporting-engine: - sql_export - sql_request_abstract odoo/odoo: - mail - base - base_setup - web - bus - web_tour - html_editor - spreadsheet_dashboard - spreadsheet - portal - web_editor - http_routing - auth_signup
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION	Allow to send the result of a query (made with the module sql_export) by mail.

Code Analysis ⓘ

Views touched (1)

XML ID	Name	Model	Type	Status
`sql_export_mail_view_form`		sql.export	button	Inherits sql_export.sql_export_view_form

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (4)

cron_ids Many2many → ir.cron
groups='base.group_system' args: 'ir.cron', 'cron_sqlquery_rel', 'sql_id', 'cron_id', 'Crons'
mail_condition Selection
default='not_empty' args: [('not_empty', 'File Not Empty')]
mail_partner_ids Many2many → res.partner
help='Add the partners who wants to receive the report by e-mail. You need to link the sql query with a cron to send a mail automatically' args: 'res.partner', 'mail_partner_sqlquery_rel', 'sql_id', 'partner_id'
mail_user_ids Many2many → res.users
help='Add the users who want to receive the report by e-mail. You need to link the sql query with a cron to send mail automatically' args: 'res.users', 'mail_user_sqlquery_rel', 'sql_id', 'user_id', 'User to notify'

Public methods (5)

check_mail_user(self)
@api.constrains('mail_user_ids')
check_no_parameter_if_sent_by_mail(self)
@api.constrains('query_properties_definition', 'mail_user_ids')
create_cron(self)
get_email_address_for_template(self)
Called from mail template. Collects email addresses from both users and partners.
send_mail(self, params=None)

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/17.0/sql_export_mail
VERSION
VERSION	1.0.0
CATEGORY
CATEGORY	Generic Modules
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Weblate, OCA-git-bot, oca-ci, Sander Lienaerts
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 19:20:00
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/reporting-engine: - sql_export - sql_request_abstract odoo/odoo: - mail - base - base_setup - web - bus - web_tour - spreadsheet_dashboard - spreadsheet - portal - web_editor - http_routing - auth_signup
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION	Allow to send the result of a query (made with the module sql_export) by mail.

Code Analysis ⓘ

Views touched (1)

XML ID	Name	Model	Type	Status
`sql_export_mail_view_form`		sql.export	button	Inherits sql_export.sql_export_view_form

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (3)

cron_ids Many2many → ir.cron
groups='base.group_system' args: 'ir.cron', 'cron_sqlquery_rel', 'sql_id', 'cron_id', 'Crons'
mail_condition Selection
default='not_empty' args: [('not_empty', 'File Not Empty')]
mail_user_ids Many2many → res.users
help='Add the users who want to receive the report by e-mail. You need to link the sql query with a cron to send mail automatically' args: 'res.users', 'mail_user_sqlquery_rel', 'sql_id', 'user_id', 'User to notify'

Public methods (5)

check_mail_user(self)
@api.constrains('mail_user_ids')
check_no_parameter_if_sent_by_mail(self)
@api.constrains('query_properties_definition', 'mail_user_ids')
create_cron(self)
get_email_address_for_template(self)
Called from mail template
send_mail(self, params=None)

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/16.0/sql_export_mail
VERSION
VERSION	2.1.0
CATEGORY
CATEGORY	Generic Modules
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Sylvain LE GAL, Florian da Costa, Weblate, OCA-git-bot, oca-ci, BT-ssteiner, joepsanders
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:53:57
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/reporting-engine: - sql_export - sql_request_abstract odoo/odoo: - mail - base - base_setup - web - bus - web_tour - spreadsheet_dashboard - spreadsheet
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (1)

XML ID	Name	Model	Type	Status
`sql_export_mail_view_form`		sql.export	button	Inherits sql_export.sql_export_view_form

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (4)

cron_ids Many2many → ir.cron
groups='base.group_system' args: 'ir.cron', 'cron_sqlquery_rel', 'sql_id', 'cron_id', 'Crons'
mail_condition Selection
default='not_empty' args: [('not_empty', 'File Not Empty')]
mail_partner_ids Many2many → res.partner
help='Add the partners who wants to receive the report by e-mail. You need to link the sql query with a cron to send a mail automatically' args: 'res.partner', 'mail_partner_sqlquery_rel', 'sql_id', 'partner_id'
mail_user_ids Many2many → res.users
help='Add the users who want to receive the report by e-mail. You need to link the sql query with a cron to send mail automatically' args: 'res.users', 'mail_user_sqlquery_rel', 'sql_id', 'user_id', 'User to notify'

Public methods (5)

check_mail_user(self)
@api.constrains('mail_user_ids')
check_no_parameter_if_sent_by_mail(self)
@api.constrains('query_properties_definition', 'mail_user_ids')
create_cron(self)
get_email_address_for_template(self)
Called from mail template. Collects email addresses from both users and partners.
send_mail(self, params=None)

REPOSITORY
REPOSITORY	OCA/reporting-engine
GIT
GIT	https://github.com/OCA/reporting-engine.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/reporting-engine/tree/15.0/sql_export_mail
VERSION
VERSION	1.0.1
CATEGORY
CATEGORY	Generic Modules
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Weblate, OCA-git-bot, oca-ci, BT-ssteiner
WEBSITE
WEBSITE	https://github.com/OCA/reporting-engine
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:46:42
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/reporting-engine: - sql_export - sql_request_abstract odoo/odoo: - mail - base - base_setup - web - bus - web_tour
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (1)

XML ID	Name	Model	Type	Status
`sql_export_mail_view_form`		sql.export	button	Inherits sql_export.sql_export_view_form

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (3)

cron_ids Many2many → ir.cron
groups='base.group_system' args: 'ir.cron', 'cron_sqlquery_rel', 'sql_id', 'cron_id', 'Crons'
mail_condition Selection
default='not_empty' args: [('not_empty', 'File Not Empty')]
mail_user_ids Many2many → res.users
help='Add the users who want to receive the report by e-mail. You need to link the sql query with a cron to send mail automatically' args: 'res.users', 'mail_user_sqlquery_rel', 'sql_id', 'user_id', 'User to notify'

Public methods (5)

check_mail_user(self)
@api.constrains('mail_user_ids')
check_no_parameter_if_sent_by_mail(self)
@api.constrains('field_ids', 'mail_user_ids')
create_cron(self)
get_email_address_for_template(self)
Called from mail template
send_mail(self, params=None)

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/14.0/sql_export_mail
VERSION
VERSION	1.0.0
CATEGORY
CATEGORY	Generic Modules
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion
COMMITTERS
COMMITTERS	OCA Transbot, oca-travis, Weblate, OCA-git-bot, hkapatel, hkapatel-initos
WEBSITE
WEBSITE	https://github.com/OCA/server-tools
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:41:05
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/server-tools: - sql_export - sql_request_abstract odoo/odoo: - base - mail - base_setup - web - bus - web_tour
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (1)

XML ID	Name	Model	Type	Status
`sql_export_mail_view_form`		sql.export	button	Inherits sql_export.sql_export_view_form

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (3)

cron_ids Many2many → ir.cron
args: 'ir.cron', 'cron_sqlquery_rel', 'sql_id', 'cron_id', 'Crons'
mail_condition Selection
default='not_empty' args: [('not_empty', 'File Not Empty')]
mail_user_ids Many2many → res.users
help='Add the users who want to receive the report by e-mail. You need to link the sql query with a cron to send mail automatically' args: 'res.users', 'mail_user_sqlquery_rel', 'sql_id', 'user_id', 'User to notify'

Public methods (5)

check_mail_user(self)
@api.constrains('mail_user_ids')
check_no_parameter_if_sent_by_mail(self)
@api.constrains('field_ids', 'mail_user_ids')
create_cron(self)
get_email_address_for_template(self)
Called from mail template
send_mail(self, params=None)

REPOSITORY
REPOSITORY	OCA/server-tools
GIT
GIT	https://github.com/OCA/server-tools.git
GIT FOLDER
GIT FOLDER	https://github.com/OCA/server-tools/tree/12.0/sql_export_mail
VERSION
VERSION	1.1.0
CATEGORY
CATEGORY	Generic Modules
LICENSE
LICENSE	AGPL-3
APPLICATION
APPLICATION	No
AUTO-INSTALLABLE
AUTO-INSTALLABLE	No
AUTHORS
AUTHORS	Odoo Community Association (OCA), Akretion, GRAP
MAINTAINERS
MAINTAINERS	Odoo Community Association (OCA), Akretion, GRAP
COMMITTERS
COMMITTERS	Sylvain LE GAL, OCA Transbot, Florian da Costa, oca-travis, OCA-git-bot
WEBSITE
WEBSITE	https://github.com/OCA/server-tools
LAST TRACKING UPDATE
LAST TRACKING UPDATE	2026-07-06 00:29:22
ODOO DEPENDENCIES
ODOO DEPENDENCIES	OCA/server-tools: - sql_export - sql_request_abstract odoo/odoo: - base - mail - base_setup - web - bus - web_tour
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES	Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES	Not have
DESCRIPTION
DESCRIPTION

Code Analysis ⓘ

Views touched (2)

XML ID	Name	Model	Type	Status
`sql_export_mail_view_form`		sql.export	button	Inherits sql_export.sql_export_view_form
`sql_export_mail_view_tree`		sql.export	field	Inherits sql_export.sql_export_view_tree

HTTP endpoints (0)

No HTTP endpoints found for this module.

Models touched (1)

New fields (5)

cron_ids Many2many → ir.cron
args: 'ir.cron', 'cron_sqlquery_rel', 'sql_id', 'cron_id', 'Crons'
mail_active Boolean
default=True string='Active Mail Sending'
mail_condition Selection
default='not_empty' args: [('not_empty', 'File Not Empty')]
mail_user_ids Many2many → res.users
help='Add the users who want to receive the report by e-mail. You need to link the sql query with a cron to send mail automatically' args: 'res.users', 'mail_user_sqlquery_rel', 'sql_id', 'user_id', 'User to notify'
option_mail_mute Boolean
default=False help="check this box if you want to disable the sending of an email, once a first email is sent. This feature is useful to implement alerts that you want to process. Once processed, you will have to 'unmute' the report." string='Deactivate After Sending'

Public methods (6)

check_mail_user(self)
@api.multi@api.constrains('mail_user_ids')
check_no_parameter_if_sent_by_mail(self)
@api.multi@api.constrains('field_ids', 'mail_user_ids')
create_cron(self)
@api.multi
get_email_address_for_template(self)
@api.multi

Called from mail template
get_url(self)
send_mail(self, params=None)
@api.multi

SQL Export Mail

Code Analysis ⓘ

Views touched (1)

HTTP endpoints (0)

Models touched (1)

sql.export Extends Model 4 fields 5 methods SqlExport · inherits sql.export

Code Analysis ⓘ

Views touched (1)

HTTP endpoints (0)

Models touched (1)

sql.export Extends Model 3 fields 5 methods SqlExport · inherits sql.export

Code Analysis ⓘ

Views touched (1)

HTTP endpoints (0)

Models touched (1)

sql.export Extends Model 4 fields 5 methods SqlExport · inherits sql.export

Code Analysis ⓘ

Views touched (1)

HTTP endpoints (0)

Models touched (1)

sql.export Extends Model 3 fields 5 methods SqlExport · inherits sql.export

Code Analysis ⓘ

Views touched (1)

HTTP endpoints (0)

Models touched (1)

sql.export Extends Model 3 fields 5 methods SqlExport · inherits sql.export

Code Analysis ⓘ

Views touched (2)

HTTP endpoints (0)

Models touched (1)

sql.export Extends Model 5 fields 6 methods SqlExport · inherits sql.export