AnsweredAssumed Answered

Lookup with parameter - not shown in list

Question asked by msnizek on Oct 5, 2015
Latest reply on Oct 5, 2015 by navzjoshi00



we have got custom investment attribute based on custom lookup (query based) with parameter. The only problem with this attribute is, that it's value is not shown in project list.


Here is my query of the lookup:

  FROM odf_ca_company ocom
left join srm_companies com on
where in 
(select pk_id from odf_multi_valued_lookups where attribute='c_com_part_rel' 
and value in (select id from cmn_partitions where code in (select case when odf_object_code='idea' 
then (select partition_code from odf_ca_idea where
when odf_object_code='project' 
then (select distinct partition_code from odf_ca_project where
end from inv_investments inv where (id=@WHERE:PARAM:USER_DEF:INTEGER:PROJECT_ID@ or @WHERE:PARAM:USER_DEF:INTEGER:PROJECT_ID@ is null)))) AND @FILTER@


Please have you got any idea, what can cause this problem?

Our Clarity version is: 06 14


Thanks in advance.


Best Regards,