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

Hello,

 

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:

SELECT
  @SELECT:ocom.id:company_id@,
  @SELECT:com.company_name:company_name@, 
  @SELECT:com.company_id:company_code@
  FROM odf_ca_company ocom
left join srm_companies com on com.id=ocom.id
where ocom.id 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 id=inv.id)
when odf_object_code='project' 
then (select distinct partition_code from odf_ca_project where id=inv.id)
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: 13.2.0.472 06 14

 

Thanks in advance.

 

Best Regards,

Martin

Outcomes