AnsweredAssumed Answered

MultiValue Lookups Not Displaying In ListView

Question asked by sohgu01 Employee on Aug 26, 2014
Latest reply on Aug 26, 2014 by sohgu01

Hi All,

 

I am on a client site and have ran into an issue where some Dynamic Multi-Value lookups do not display data in listview. We have tweaked the query and also found out that it doesn't work, while mapping parameters to Virtual Attributes, but we do not want to create duplicate attributes. Have you guys encountered something like this? Thanks in Advance

 

Dynamic Lookup Query:

 

SELECT DISTINCT @SELECT:mvl.Value:VALUE@,

        @SELECT:pp2.NAME:NAME@

from odf_multi_valued_lookups mvl

join odf_ca_bp_port_params pp1 on pp1.id = mvl.pk_id and mvl.attribute = 'bp_port_child'

join odf_ca_bp_port_params pp2 on pp2.code = mvl.value

join odf_ca_inv inv ON inv.bp_portfolio = mvl.value

join odf_ca_bp_moc moc on moc.odf_parent_id = inv.id

where @FILTER@

@BROWSE-ONLY:

AND 1 =

CASE WHEN pp1.code = @WHERE:PARAM:USER_DEF:INTEGER:p_self@ and @WHERE:PARAM:USER_DEF:INTEGER:p_self@ IS NOT NULL

      THEN 1

      when @WHERE:PARAM:USER_DEF:INTEGER:p_self@ is null

      Then 1

ELSE 0 END

:BROWSE-ONLY@

Outcomes