CR newbee

[pdom09]

Is it possible to write the query code below in CRXI as it is written? if so, how?

[Select *
from LMGHRDB.lm_ghr.EMPLOYEE
left join LMGHRDB.lm_ghr.EMPLOYEECONTACT
ON EMPLOYEE.EMPLOYEE = EMPLOYEECONTACT.EMPLOYEE
AND EMPLOYEECONTACT.CONTACTMETHOD = 1
AND EMPLOYEECONTACT.[DESCRIPTION] IN ('Work', 'Work Phone')
left join LMGHRDB.lm_ghr.EMPLOYEEBENEFIT
ON EMPLOYEEBENEFIT.EMPLOYEE = EMPLOYEE.EMPLOYEE
and EMPLOYEEBENEFIT.HRORGANIZATION = EMPLOYEE.HRORGANIZATION
AND EMPLOYEEBENEFIT.DELETEFLAG = 0x00000000000000000000000000000000
and EMPLOYEEBENEFIT.BENEFITPLAN in ('STD BUY UP', 'STD CORE','LTD CORE', 'LTD BUY UP', 'LTD MGR', 'LTD EXEC PHYS')
and EMPLOYEEBENEFIT.STATUS = 6
left join LMGHRDB.lm_ghr.WORKASSIGNMENTEXPORT
on WORKASSIGNMENTEXPORT.EMPLOYEE = EMPLOYEE.EMPLOYEE
and WORKASSIGNMENTEXPORT.HRORGANIZATION= EMPLOYEE.HRORGANIZATION
and WORKASSIGNMENTEXPORT.WORKASSIGNMENT = EMPLOYEE.PRIMARYWORKASSIGNMENT
and WORKASSIGNMENTEXPORT.ACTIONTYPE = 1
left join LMGHRDB.lm_ghr.WORKASSIGNMENT
on EMPLOYEE.EMPLOYEE = WORKASSIGNMENT.EMPLOYEE
and EMPLOYEE.HRORGANIZATION = WORKASSIGNMENT.HRORGANIZATION
and EMPLOYEE.PRIMARYWORKASSIGNMENT = WORKASSIGNMENT.WORKASSIGNMENT
AND WORKASSIGNMENT.DELETEFLAG = 0x00000000000000000000000000000000
left join LMGHRDB.lm_ghr.EMPLOYEETHIRDPARTYPAYROLL
on EMPLOYEE.HRORGANIZATION = EMPLOYEETHIRDPARTYPAYROLL.HRORGANIZATION
and EMPLOYEE.EMPLOYEE = EMPLOYEETHIRDPARTYPAYROLL.EMPLOYEETHIRDPARTYPAYROLL
AND EMPLOYEETHIRDPARTYPAYROLL.DELETEFLAG = 0x00000000000000000000000000000000
left join LMGHRDB.lm_ghr.HRORGANIZATIONUNIT
on HRORGANIZATIONUNIT.HRORGANIZATION = WORKASSIGNMENT.HRORGANIZATION
and HRORGANIZATIONUNIT.HRORGANIZATIONUNIT = WORKASSIGNMENT.HRORGANIZATIONUNIT
left join LMGHRDB.lm_ghr.HRLOCATION
on HRLOCATION.HRLOCATION = WORKASSIGNMENT.LOCATION
left join LMGHRDB.lm_ghr.POSITION
on POSITION.HRORGANIZATION = EMPLOYEE.HRORGANIZATION
and POSITION.POSITION = WORKASSIGNMENT.POSITION
left join LMGHRDB.lm_ghr.USERFIELD_STORAGE
on USERFIELD_STORAGE.UFSUNIQUEID = POSITION.UNIQUEID
AND USERFIELD_STORAGE.UFSFIELDNAME = 'TechShiftDiff'
AND USERFIELD_STORAGE.UFSCLASSNAME = 'Position'
left join LMGHRDB.lm_ghr.EMPLOYEEADDRESS
on EMPLOYEEADDRESS.EMPLOYEE = EMPLOYEE.EMPLOYEE
and EMPLOYEEADDRESS.EMPLOYEEADDRESS = EMPLOYEE.USEFORMAILING
where EMPLOYEE.RELATIONSHIPSTATUS = 'ACTIVE'
and EMPLOYEE.DELETEFLAG = 0x00000000000000000000000000000000][/code]

 

[IanWaterman]

Use a command as your data source.
Paste your sql in there.
Ian