danielkmog

Join Query for Assigned To Field

Discussion created by danielkmog on Jul 10, 2013
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

Outcomes