Unable to run Query
Good Morning
I have upgraded our version of ServiceDesk from 10017 to 11100 and am unable to run some of my reports anymore.
The one below is for our HD Productivity - Today report that was created. We are on PQSQL.
Thank You
select DISTINCT(re.first_name) "Technician",
count (case when woh.operation='RESOLVED' then 1 else null end) "Resolved",
count(case when woh.operation='CLOSE' then 1 else null end) "Closed",
count(case when woh.operation='UPDATE' then 1 else null end) "Modify"
from workorderhistory woh
left join workorder wo on woh.workorderid=wo.workorderid
left join aaauser re on woh.operationownerid=re.user_id
INNER JOIN HelpDeskCrew ON re.USER_ID=HelpDeskCrew.TECHNICIANID
where
woh.operationtime>= <from_today> AND woh.operationtime<= <to_today>
group by re.first_name