Hi,I'm building some WFM queries for different job types and would like to show the 'Full Name' instead of the 'User Name' (e.g., JOD123). The 'Assign To' field contains group names as well (e.g. Techs or QAQC), so when it generates the query it leaves out.I could change all my steps to point directly to the assigned user (to remove the group from the Assigned To field), but in the event that I would need to assign another user to a job; I would be forced to go through each step and change to the new user.Has anyone attempted a join query through the Workflow Manager and would be willing provide some assistance?Thank you,Daniel
SELECT JTX_JOBS.JOB_ID,gis.GISDC.WMX_ASBUILT_INFO.DOC_NUM,JTX_PRIORITY.NAME,JTX_JOBS.JOB_NAME,JTX_JOBS.CREATED_DATE,JTX_JOBS.ASSIGNED_TO,JTX_JOBS.PERC_COMPLETE,JTX_STATUS.CAPTION,gis.GISDC.WMX_ASBUILT_INFO.QAQC_DATE
FROM JTX_JOBS,gis.GISDC.WMX_ASBUILT_INFO,JTX_PRIORITY,JTX_STATUS
WHERE gis.GISDC.WMX_ASBUILT_INFO.JOB_ID=JTX_JOBS.JOB_ID AND JTX_PRIORITY.PRIORITY_LEVEL=JTX_JOBS.PRIORITY AND JTX_STATUS.ID=JTX_JOBS.STATUS
