Report per Site
Hi I want to have a Report per site.
Does some one knows how to make this report?
Field Site is the Site from the Admin --> Sites entries.
THX for Help!
SELECT dpt.DEPTNAME 'Department',
wof.UDF_CHAR1 'Filed SITE', <-- THIS is what I'm searching for
wo.WORKORDERID 'Request ID'
FROM WorkOrder_Threaded wot
INNER JOIN WorkOrder wo ON wot.WORKORDERID=wo.WORKORDERID
LEFT JOIN DepartmentDefinition dpt ON wo.DEPTID=dpt.DEPTID
LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID
WHERE (wot.THD_WOID=wot.WORKORDERID)
Does some one knows how to make this report?
Field Site is the Site from the Admin --> Sites entries.
THX for Help!