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

Module: Project

Entity: project.project

Compute Method: _compute_attached_docs_count

View 17.0
Inputs Method Outputs
  • id
- docs_count = {}
- if self.ids:
-             self.env.cr.execute(
-                 """
-                 WITH docs AS (
-                      SELECT res_id as id, count(*) as count
-                        FROM ir_attachment
-                       WHERE res_model = 'project.project'
-                         AND res_id IN %(project_ids)s
-                    GROUP BY res_id
- 
-                   UNION ALL
- 
-                      SELECT t.project_id as id, count(*) as count
-                        FROM ir_attachment a
-                        JOIN project_task t ON a.res_model = 'project.task' AND a.res_id = t.id
-                       WHERE t.project_id IN %(project_ids)s
-                    GROUP BY t.project_id
-                 )
-                 SELECT id, sum(count)
-                   FROM docs
-               GROUP BY id
-                 """,
-                 {"project_ids": tuple(self.ids)}
-             )
-             docs_count = dict(self.env.cr.fetchall())
- for project in self:
-             project.doc_count = docs_count.get(project.id, 0)
  • doc_count

Back to entity