projects
/
odoo
/
odoo.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
[IMP] crm*: update crm modules to new mail module (wip)
[odoo/odoo.git]
/
addons
/
crm_helpdesk
/
report
/
crm_helpdesk_report.py
diff --git
a/addons/crm_helpdesk/report/crm_helpdesk_report.py
b/addons/crm_helpdesk/report/crm_helpdesk_report.py
index
56fe2dd
..
fb5efdc
100644
(file)
--- a/
addons/crm_helpdesk/report/crm_helpdesk_report.py
+++ b/
addons/crm_helpdesk/report/crm_helpdesk_report.py
@@
-97,7
+97,7
@@
class crm_helpdesk_report(osv.osv):
c.planned_cost,
count(*) as nbr,
extract('epoch' from (c.date_closed-c.create_date))/(3600*24) as delay_close,
c.planned_cost,
count(*) as nbr,
extract('epoch' from (c.date_closed-c.create_date))/(3600*24) as delay_close,
- (SELECT count(id) FROM email_message WHERE model='crm.helpdesk' AND res_id=c.id AND history=True) AS email,
+ (SELECT count(id) FROM email_message WHERE model='crm.helpdesk' AND res_id=c.id AND email_from IS NOT NULL) AS email,
abs(avg(extract('epoch' from (c.date_deadline - c.date_closed)))/(3600*24)) as delay_expected
from
crm_helpdesk c
abs(avg(extract('epoch' from (c.date_deadline - c.date_closed)))/(3600*24)) as delay_expected
from
crm_helpdesk c