AnsweredAssumed Answered

OBS Unitmode Parameter

Question asked by ramp80 on Mar 11, 2010
Latest reply on Mar 12, 2010 by Dave
How would I add the OBS Unitmode Parameter to the following NSQL extract:  AND (@WHERE:PARAM:USER_DEF:INTEGER:OBS@ is null OR EXISTS ( SELECT 1 FROM prj_obs_associations ASSOC, prj_obs_units_flat FLAT
WHERE a.prresourceid = ASSOC.record_id AND ASSOC.table_name = 'SRM_RESOURCES' AND ASSOC.unit_id = FLAT.unit_id
AND FLAT.branch_unit_id = @WHERE:PARAM:USER_DEF:INTEGER:OBS@))  Thanks,  -R

Outcomes