Odoo Mindscape. Understand Odoo faster. Explore modules, fields, dependencies and version differences in one place instead of digging through the source code.

Module: Email Marketing

Entity: mailing.list

Compute Method: _compute_mailing_count

Inputs Method Outputs 
data = {}
if self.ids:
            self.env.cr.execute('''
                SELECT mailing_list_id, count(*)
                FROM mail_mass_mailing_list_rel
                WHERE mailing_list_id IN %s
                GROUP BY mailing_list_id''', (tuple(self.ids),))
            data = dict(self.env.cr.fetchall())
for mailing_list in self:
            mailing_list.mailing_count = data.get(mailing_list._origin.id, 0)

Back to entity