AnsweredAssumed Answered

Multi-Values in Filter Portlet.

Question asked by globons on Jul 18, 2012
Latest reply on Jul 19, 2012 by globons
Hi All,

I have created the following query in Clarity 12.1.0.5840 6 001:


SELECT @SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJECT:PROJECT.name:ProjectName@,

@SELECT:DIM_PROP:USER_DEF:IMPLIED:PROJECT:(select NAME from CMN_LOOKUPS_V where LOOKUP_TYPE = 'PROJECT_STATE' AND LANGUAGE_CODE = 'en' AND LOOKUP_CODE = CUSTOM.PROJECT_STATE):ProjectState@

FROM niku.INV_INVESTMENTS PROJECT


INNER JOIN niku.odf_ca_inv CUSTOM ON (PROJECT.id = CUSTOM.ID)

WHERE (@WHERE:PARAM:USER_DEF:STRING:ProjectState@ IS NULL



OR CUSTOM.PROJECT_STATE in (@WHERE:PARAM:USER_DEF:STRING:ProjectState@))

AND @FILTER@

After that, I assigned a Lookup query to "ProjectState" Query Attribute.

Then, I created a Custom Portlet and added my Custom Query but I could not be able to create a Multiple-Values "ProjectState" portlet filter.

If I checked "List Filter Section"-"Fields", "Filter Label ProjectState" properties (DataType "Lookup - String"), I could not be selected "multiple-values" choice because it did not appear.

Any ideas?

Thanks in advance
Regards
Gerardo

Outcomes