Problem with getting full description from email conversations
Hello everyone,
I need little help with reports.
With this select I get descriptiom from email but only first replay, I need to get all conversation between tehnician and requester.
SELECT aau.FIRST_NAME "Podnosilac zahtjeva",wo.WORKORDERID "ID zahtjeva",wo.CREATEDTIME "Vrijeme kreiranja",wo.COMPLETEDTIME "Vrijeme završetka",wo.TITLE "Predmet",wotodesc.FULLDESCRIPTION "Opis" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (((aau.FIRST_NAME = 'Company') AND (std.STATUSNAME = 'Closed')) AND (((wo.COMPLETEDTIME >= 1422745200000) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL))) AND ((wo.COMPLETEDTIME <= 1425164399000) AND (((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL)) AND (wo.COMPLETEDTIME != -1))))) AND wo.ISPARENT='1'
I need little help with reports.
With this select I get descriptiom from email but only first replay, I need to get all conversation between tehnician and requester.
SELECT aau.FIRST_NAME "Podnosilac zahtjeva",wo.WORKORDERID "ID zahtjeva",wo.CREATEDTIME "Vrijeme kreiranja",wo.COMPLETEDTIME "Vrijeme završetka",wo.TITLE "Predmet",wotodesc.FULLDESCRIPTION "Opis" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (((aau.FIRST_NAME = 'Company') AND (std.STATUSNAME = 'Closed')) AND (((wo.COMPLETEDTIME >= 1422745200000) AND ((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL))) AND ((wo.COMPLETEDTIME <= 1425164399000) AND (((wo.COMPLETEDTIME != 0) AND (wo.COMPLETEDTIME IS NOT NULL)) AND (wo.COMPLETEDTIME != -1))))) AND wo.ISPARENT='1'