mysql query error
Hi All,
When I use this query in the My SQL Query Browser, it works like a charm, but I get a compile error when used within SD+.
I'm running 7008, on a trial Enterprise version in English. The query I used is:
select
wo.workorderid RequestId,
wo.title Subject,
au.first_name Technician,
date_format(from_unixtime(STARTTIME/1000), '%m-%d-%Y %k:%i') Onhold,
date_format(from_unixtime(ENDTIME/1000), '%m-%d-%Y %k:%i') Resumed,
TIMEDIFF(from_unixtime(ENDTIME/1000), from_unixtime(STARTTIME/1000)) 'Time on hold'
from WorkOrder wo
join RequestOnHold ro on wo.workorderid = ro.workorderid
left join WorkOrderStates wos on wo.workorderid = wos.workorderid
left join AaaUser au on wos.ownerid = au.user_id
order by 1, 4
What I'm trying to accomplish is that I get an overview of the time spent on hold per request (and if possible a sum per request), since we're dependant on several other departments for call handling for functional application support.
Could someone help point me in the right direction?
Thank you in advance!
Kind regards,
Paul
When I use this query in the My SQL Query Browser, it works like a charm, but I get a compile error when used within SD+.
I'm running 7008, on a trial Enterprise version in English. The query I used is:
select
wo.workorderid RequestId,
wo.title Subject,
au.first_name Technician,
date_format(from_unixtime(STARTTIME/1000), '%m-%d-%Y %k:%i') Onhold,
date_format(from_unixtime(ENDTIME/1000), '%m-%d-%Y %k:%i') Resumed,
TIMEDIFF(from_unixtime(ENDTIME/1000), from_unixtime(STARTTIME/1000)) 'Time on hold'
from WorkOrder wo
join RequestOnHold ro on wo.workorderid = ro.workorderid
left join WorkOrderStates wos on wo.workorderid = wos.workorderid
left join AaaUser au on wos.ownerid = au.user_id
order by 1, 4
What I'm trying to accomplish is that I get an overview of the time spent on hold per request (and if possible a sum per request), since we're dependant on several other departments for call handling for functional application support.
Could someone help point me in the right direction?
Thank you in advance!
Kind regards,
Paul