SQL Export Mail

sql_export_mail · OCA/reporting-engine

    Repository
    OCA/reporting-engine · module folder · Try on Runboat
    Module version
    1.0.0
    Category
    Generic Modules
    Folder size
    0.05 MB
    License
    AGPL-3
    Application
    No
    Auto-installable
    No
    Website
    https://github.com/OCA/reporting-engine
    Last tracking update
    2026-08-07 08:43:02
    Authors
    Akretion, Odoo Community Association (OCA), GRAP
    Maintainers
    Akretion, Odoo Community Association (OCA), GRAP
    Committers
    Lars Quaedvlieg, OCA-git-bot, oca-ci
    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
    None
    System dependencies
    None
    Required by
    None
    Description
    Allow to send the result of a query (made with the module sql_export) by
mail.

    Code Analysis ⓘ

    Views touched (1)
    XML IDNameModelTypeStatus
    sql_export_mail_view_form sql.export form 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)

    Loading…

    Loading…

    Loading…

    Loading…

    Loading…