Update Url survey because is broken
Hi, I have a query with the url of survey
BEFORE
http://MYSERVER/sd/SurveyDetails.sd?surveyMode=newSurvey&surveyID=182709&userID=2104 (It´s Broken, bad.)
NOW
http://MYSERVER/sd/SurveyDetails.sd?surveyData=2fbb38a41e336d1f38668bf256bd122408d3be2f (It´s Works, Good)
Query:
SELECT w.siteid, sd.name, LONGTODATE(s1.createdtime) "fecha resultado de la encuesta",w.workorderid "Request ID", w.title, LONGTODATE(w.createdtime) "Fecha Creación de la Solicitud", aa.first_name "Requester Name", emailid "Requester E-Mail", s.SURVEYID "Survey ID", w.REQUESTERID "User ID", concat(concat(concat('
http://MYSERVER/sd/SurveyDetails.sd?surveyMode=newSurvey&surveyID=',s.SURVEYID),'&userID='),w.REQUESTERID) "Link de la encuesta del cliente" FROM surveyperrequest s LEFT JOIN surveyperrequestext s1 ON s1.surveyid = s.surveyid INNER JOIN workorder w ON w.workorderid = s.workorderid INNER JOIN aaauser aa ON aa.user_id = w.requesterid LEFT JOIN aaausercontactinfo aauc ON aa.user_id = aauc.user_id LEFT JOIN aaacontactinfo aac ON aac.contactinfo_id = aauc.contactinfo_id INNER JOIN sdorganization sd ON sd.org_id = w.siteid WHERE s1.surveyid IS NULL and w.createdtime > DATETOLONG('2015-12-01 00:00:00') and w.siteid not in(9001, 902, 6601) order by 1, 4
The Output is
But problem this url of query is broken, i need the update the query with the new url of All my survey.