Hello,

We recently upgraded from 10+ to the most recent 11+ version.  I have reports that are no longer working.  This report gives information about tickets which haven't been updated within the last 7 days, it's currently showing tickets that have been updated.  Can somebody help me troubleshoot why it's not giving accurate info since the upgrade?

SELECT wo.WORKORDERID "Request ID", aau.FIRST_NAME "Requester", wo.TITLE "Subject", ti.FIRST_NAME "Technician", LONGTODATE(wo.CREATEDTIME) "Created Time" FROM WorkOrder wo LEFT JOIN ModeDefinition mdd ON wo.MODEID = mdd.MODEID LEFT JOIN SDUser sdu ON wo.REQUESTERID = sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID = aau.USER_ID LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID = dpt.DEPTID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID = wotodesc.WORKORDERID LEFT JOIN SiteDefinition siteDef ON wo.SITEID = siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID = sdo.ORG_ID LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID = woq.WORKORDERID LEFT JOIN QueueDefinition qd ON woq.QUEUEID = qd.QUEUEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID = wos.WORKORDERID LEFT JOIN SubCategoryDefinition scd ON wos.SUBCATEGORYID = scd.SUBCATEGORYID LEFT JOIN CategoryDefinition cd ON wos.CATEGORYID = cd.CATEGORYID LEFT JOIN SDUser td ON wos.OWNERID = td.USERID LEFT JOIN AaaUser ti ON td.USERID = ti.USER_ID LEFT JOIN StatusDefinition std ON wos.STATUSID = std.STATUSID WHERE (std.ispending = '1') AND NOT ((std.statusname = 'project' OR std.statusname = 'problem')) AND wo.ISPARENT = '1' AND DATEDIFF(day, dateadd(s, datediff(s, GETUTCDATE(), getdate()) + (wo.createdtime / 1000), '1970-01-01 00:00:00'), GETDATE()) > 0 AND DATEDIFF(day, dateadd(s, datediff(s, GETUTCDATE(), getdate()) + (wos.LAST_TECH_UPDATE / 1000), '1970-01-01 00:00:00'), GETDATE()) > 7