diff options
| author | Nicolas Martinelli <nim@odoo.com> | 2017-08-24 11:15:13 +0200 |
|---|---|---|
| committer | Nicolas Martinelli <nim@odoo.com> | 2017-08-24 11:15:13 +0200 |
| commit | 7ec4f2d6f5e5974f9e16b60fde305477668a39d3 (patch) | |
| tree | 339cb017e61ccc414eaa38c848c07c6cd8f61d5e | |
| parent | 420e433fa3a6b671868fa578e6006dd215570706 (diff) | |
[FIX] project: # Days to Close
Take into account the End Date for task analysis.
opw-767245
| -rw-r--r-- | addons/project/report/project_report.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/addons/project/report/project_report.py b/addons/project/report/project_report.py index 00d739ec9c4..cddd6722ba5 100644 --- a/addons/project/report/project_report.py +++ b/addons/project/report/project_report.py @@ -58,7 +58,7 @@ class ReportProjectTaskUser(models.Model): t.partner_id, t.stage_id as stage_id, t.kanban_state as state, - (extract('epoch' from (t.write_date-t.create_date)))/(3600*24) as closing_days, + (extract('epoch' from (NULLIF(t.date_end, t.write_date)-t.create_date)))/(3600*24) as closing_days, (extract('epoch' from (t.date_start-t.create_date)))/(3600*24) as opening_days, (extract('epoch' from (t.date_deadline-(now() at time zone 'UTC'))))/(3600*24) as delay_endings_days """ |