different results between flash and matrix report
I have different results between flash and matrix reports. What is the Problem?
The Query of the matrix report (result is in the attachment)is the following:
SELECT wo.CREATEDTIME "Created Time",sdo.NAME "Site",wo.WORKORDERID "Request ID" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN LevelDefinition lvd ON wos.LEVELID=lvd.LEVELID WHERE (((( lvd.LEVELNAME != 'AirQuest Support') AND ( lvd.LEVELNAME != 'Database Support')) OR ( lvd.LEVELNAME IS NULL)) AND (((wo.CREATEDTIME >= <from_yesterday>) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= <to_yesterday>) AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1)))))
A picture fro the flash report is in the attached picture
The Query of the matrix report (result is in the attachment)is the following:
SELECT wo.CREATEDTIME "Created Time",sdo.NAME "Site",wo.WORKORDERID "Request ID" FROM WorkOrder_Threaded wot INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID LEFT JOIN SiteDefinition siteDef ON wo.SITEID=siteDef.SITEID LEFT JOIN SDOrganization sdo ON siteDef.SITEID=sdo.ORG_ID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN LevelDefinition lvd ON wos.LEVELID=lvd.LEVELID WHERE (((( lvd.LEVELNAME != 'AirQuest Support') AND ( lvd.LEVELNAME != 'Database Support')) OR ( lvd.LEVELNAME IS NULL)) AND (((wo.CREATEDTIME >= <from_yesterday>) AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= <to_yesterday>) AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1)))))
A picture fro the flash report is in the attached picture