Closed Work with an Employee with no entered time
This filter finds a list of work orders that have an employee resource record where no time was entered. It is then sorted to show the Work Order, Task, and Employee.
WKORDER LEFT JOIN WKWOTSK ON WKORDER.WO_ID = WKWOTSK.WT_WO_ID LEFT JOIN WKRESRCE ON WKWOTSK.WT_ID = WKRESRCE.WR_WT_ID AND WKRESRCE.WR_RTYP_CD = 1 WHERE (WKRESRCE.WR_UNITS_GT = 0 AND WKORDER.WO_STAT_CD >= 950)
WKORDER - WO_DEPT_TY
WKORDER - WO_NUMBER
WKWOTSK - WT_TASK_TY
WKRESRCE - WR_RSRC_TY
Please sign in to leave a comment.