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: 188.8.131.522 06 14
Thanks in advance.