Dear All,
I have requirement to fill a lookup attribute based on the dept obs of the resource in resource object. As dept obs is derived from the obs association table, am not able to do a parameterized lookup.
I was trying Xpath construct in nsql lookup query, query succeeded. but the lookup is not getting the xpath value. Does anyone has any better idea or suggestion .
code am using
select
@SELECT:mvl.value:squad@,
@SELECT:mvl.dwh_value:squadname@
from
(select value,pk_id,dwh_value from ODF_MULTI_VALUED_LOOKUPS
where object ='department')mvl
inner join departments dpt
on mvl.pk_id =dpt.id
inner join prj_obs_units pou
on dpt.obs_unit_id =pou.id
inner join prj_obs_associations poa
on pou.id =poa.unit_id
and poa.table_name ='SRM_RESOURCES'
inner join srm_resources srm
on srm.id =poa.record_id
where srm.id =@where:param:xml:INTEGER:/data/id/@value@
and @FILTER@