Hello,

 

We are currently experiencing multiple "Ratings" for single request incidents (when producing Survey Reports) and therefore we produce incorrect reporting results.

 

Is this a known issue or am I just creating a custom report incorrectly?

 

Here is the QUERY. Thanks for your assistance.

 

==============================================================

 

SELECT sadt.ANSVALUES "Rating",spre.CREATEDTIME "Survey Created Time",sadt.ANSVALUES "Rating",wo.WORKORDERID "Request ID",ti.FIRST_NAME "Technician",aau.FIRST_NAME "Requester",spre.COMMENTS "Comments" 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 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 LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID WHERE  (((spre.CREATEDTIME >= 1316872800000) AND ((spre.CREATEDTIME != 0) AND (spre.CREATEDTIME IS NOT NULL))) AND ((spre.CREATEDTIME <= 1317477599000) AND (((spre.CREATEDTIME != 0) AND (spre.CREATEDTIME IS NOT NULL)) AND (spre.CREATEDTIME != -1))))  ORDER BY 1