AnsweredAssumed Answered

Project OBS

Question asked by Keri Taylor on Sep 1, 2009
Latest reply on Sep 3, 2009 by Keri Taylor
How do i attach the obs for use  with obs filter, when I want the obs filter to NOT be required?   SELECT
tm.prProjectID prprojectid,
tm.prResourceID prresourceid,
p.name project,
p.code projectid,
(select top 1 full_name from ( SELECT SRM_RESOURCES.ID ID,
SRM_RESOURCES.LAST_NAME LAST_NAME,
SRM_RESOURCES.FIRST_NAME FIRST_NAME,
SRM_RESOURCES.FULL_NAME FULL_NAME,
SRM_RESOURCES.UNIQUE_NAME UNIQUE_NAME,
SRM_RESOURCES.UNIQUE_NAME UNIQUE_CODE
FROM SRM_RESOURCES, PRJ_RESOURCES WHERE
SRM_RESOURCES.ID=PRJ_RESOURCES.PRID) q where q.id = tm.prResourceID) resource_caption

FROM
PRTEAM tm,
INV_INVESTMENTS p
LEFT OUTER JOIN prj_obs_associations assoc ON p.id = assoc.record_id
LEFT OUTER JOIN prj_obs_units_flat flat ON assoc.unit_id = flat.unit_id,
SRM_RESOURCES r

WHERE
p.ID=tm.prProjectID
AND r.ID=tm.prResourceID
AND tm.PRPROJECTID=5001526
AND assoc.table_name = 'SRM_PROJECTS'
AND flat.branch_unit_id = 5002880

Outcomes