AnsweredAssumed Answered

Returning Portlet Filter values to the Portlet Grid Results

Question asked by jadams_nyc on Oct 16, 2009
Latest reply on Jun 23, 2011 by Dave
Is it possible to return portlet filter values to the portlet grid results. I would like to be able to filter by a date range but then return the filter range values to the results set.    Here is the general idea (but this doesnt work):  SELECT @SELECT:DIM:USER_DEF:IMPLIED:INVESTMENT:V.UNIQUE_ID:UNIQUE_ID@,
      @SELECT:DIM_PROP:USER_DEF:IMPLIED:INVESTMENT:V.PROJECT:PROJECT@,
      @SELECT:DIM_PROP:USER_DEF:IMPLIED:INVESTMENT:V.WEEK_ENDING:WEEK_ENDING@,
      @SELECT:DIM_PROP:USER_DEF:IMPLIED:INVESTMENT:V.FILTER_VALUE_FROM:FILTER_VALUE_FROM@ ,       @SELECT:DIM_PROP:USER_DEF:IMPLIED:INVESTMENT:V.FILTER_VALUE_TO:FILTER_VALUE_TO@ FROM (
      SELECT (I.ID || S.ID) UNIQUE_ID,
              I.NAME PROJECT,
              S.WEEK_ENDING WEEK_ENDING,
              @WHERE:PARAM:USER_DEF:DATE:WEEK_ENDING_FROM @ FILTER_VALUE_FROM ,               @WHERE:PARAM:USER_DEF:DATE:WEEK_ENDING_TO @ FILTER_VALUE_TO
      FROM INV_INVESTMENTS I
              JOIN ODF_CA_STATUS S ON I.ID = S.ODF_PARENT_ID) V
WHERE 1 = 1
      AND @FILTER@  Where WEEK_ENDING_FROM and WEEK_ENDING_TO are the references to what the @FILTER@ produces when you do a SQL preview:  ...AND V.WEEK_ENDING >= :week_ending_from
AND V.WEEK_ENDING

Outcomes