Please help Custom Report loops
Can someone help me with this query? I built in the report module. The app should not let this occur (IMHO) The report loops through several times for each instance
SELECT ti.FIRST_NAME "Technician",wot.THD_WOID "Request ID",spre.COMMENTS "Comments",sadt.ANSVALUES "Rating",wo.CREATEDTIME "Request Created Time",wo.RESPONDEDTIME "Responded Date",wo.COMPLETEDTIME "Completed Time",mdd.MODENAME "Request Mode" FROM SurveyPerRequest spr INNER JOIN SurveyPerRequestExt spre ON spr.SURVEYID=spre.SURVEYID LEFT JOIN SurveyDetails sdt ON spre.SURVEYID=sdt.SURVEYID LEFT JOIN SurveyAnswers sadt ON sdt.SURANSID=sadt.SURANSID LEFT JOIN WorkOrder wo ON spr.WORKORDERID=wo.WORKORDERID INNER JOIN WorkOrder_Threaded wot ON wo.WORKORDERID=wot.THD_WOID LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID WHERE (((wo.COMPLETEDTIME >= 1213588800538) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL))) AND ((wo.COMPLETEDTIME <= 1214020799537) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL)))) ORDER BY 1
SELECT ti.FIRST_NAME "Technician",wot.THD_WOID "Request ID",spre.COMMENTS "Comments",sadt.ANSVALUES "Rating",wo.CREATEDTIME "Request Created Time",wo.RESPONDEDTIME "Responded Date",wo.COMPLETEDTIME "Completed Time",mdd.MODENAME "Request Mode" FROM SurveyPerRequest spr INNER JOIN SurveyPerRequestExt spre ON spr.SURVEYID=spre.SURVEYID LEFT JOIN SurveyDetails sdt ON spre.SURVEYID=sdt.SURVEYID LEFT JOIN SurveyAnswers sadt ON sdt.SURANSID=sadt.SURANSID LEFT JOIN WorkOrder wo ON spr.WORKORDERID=wo.WORKORDERID INNER JOIN WorkOrder_Threaded wot ON wo.WORKORDERID=wot.THD_WOID LEFT JOIN ModeDefinition mdd ON wo.MODEID=mdd.MODEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser td ON wos.OWNERID=td.USERID LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID WHERE (((wo.COMPLETEDTIME >= 1213588800538) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL))) AND ((wo.COMPLETEDTIME <= 1214020799537) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL)))) ORDER BY 1