2 Replies Latest reply: Feb 15, 2012 12:13 PM by user5914526 RSS

    Record Group Query - item block

    user5914526
      I need to calculate a Record Group Query using a block item value, but when a use the query below the query didn't return rows:
      SELECT OID_SIIB_FINALIDADE_TED
           , F.COD_FINALIDADE || ' - ' || F.DES_FINALIDADE DES_FINALIDADE
        FROM SIIB_FINALIDADE_TED F
            , ( SELECT P.TP_PARAMETRO 
                  FROM SIIB_PARAMETROS_GERAIS P   
                WHERE P.NM_PARAMETRO = 'TIPO_' || :BLOCK.ITEMX ) PAR -- using the :BLOCK.ITEMX the query did'nt return data
       WHERE PAR.TP_PARAMETRO = F.TPO_FINALIDADE
      But if a use a static query the Record Group( changing :BLOCK.ITEMX for 'STR0005' ) return the desired values.

      This Record Group is used to pupulate a LOV.

      Edited by: user5914526 on Feb 15, 2012 9:26 AM

      Edited by: user5914526 on Feb 15, 2012 9:26 AM

      Edited by: user5914526 on Feb 15, 2012 9:29 AM