Can I get this in SQL
Hi
This post is what I need to do in Analytics plus - but it is in postgresql
Can I get the query in MS SQL?
- SELECT aau.first_name AS "Technician", now() AS "Date", Count(wo.WORKORDERID) AS "Requests" FROM WorkOrder wo LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN SDUser sdu ON wos.OwnerID = sdu.UserID LEFT JOIN AaaUser aau ON sdu.UserID = aau.User_ID LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID WHERE (std.ISPENDING = true) AND wo.ISPARENT='1' GROUP BY 1