APEX Reports with dynamic help text in Oracle APEX 4.2 using CSS

Objective:
To
show dynamic help text in APEX reports (Interactive/classical) in Oracle APEX
4.2 using CSS.
Solution:
Step 1: Create Interactive
report
Step 2: Use below
query in IR Region source.
<<SQL
Begins>>
SELECT
  *
FROM
  (
    SELECT
      ROWNUM LEVEL_VALUE ,
      UPPER(TARGET) TARGET,
      STARTED_BY
    FROM
      (
        SELECT
          (‘<span
style=”cursor:help” title=”‘
          || UPPER(REPORTNAME)
          || ‘”>’
          || (
            CASE
              WHEN AA.SUB_PAGEID !=:APP_PAGE_ID
              THEN ‘<a href=”‘
                ||’f?p=&APP_ID.:’
                ||AA.SUB_PAGEID
                ||’:’
               
|| :APP_SESSION
                ||’:::’
                ||AA.SUB_PAGEID
                ||’:”>’
                ||INITCAP(AA.SUBTABNAME)
                ||’ </a>’
              ELSE ‘<font color=purple>’
                ||INITCAP(AA.SUBTABNAME)
                ||'</font>’
            END)
          || ‘</span>’) AS TARGET,
          TRIM(UPPER(AA.SUBTABNAME)) REP_ORD ,
          AB.MAKER_ID AS “STARTED_BY”
        FROM
          REP_DEPT_REPORT_MAP_DETAILS AA,
          DS_REP_REPORT_MASTER AB
        WHERE
          AA.REPID IN
          (
            SELECT DISTINCT
              RSD.REPORTID
            FROM
              REP_ROLE_DEPT_REPORT_MAP RSD,
              REP_ROLE_DEPT_MAP RD,
              REP_USER_MASTER UM,
              REP_USER_ROLE_MAP UD,
              REP_ROLE_MASTER RM,
              REP_DEPARTMENT_SUB_MASTER DSM,
              REP_DEPT_REPORT_MAP_DETAILS
REPTD,
              REP_ROLE_DEPT_SUB_MAP RRDSM,
              DS_REP_REPORT_MASTER DRP
            WHERE
              RSD.DEPTID               =RD.DEPTID
            AND
TRIM(UPPER(UM.USER_ID))=TRIM(UPPER(:P0_USERID))
            AND UM.USER_ID             =UD.USER_ID
            AND RD.ROLEID              =UD.ROLEID
            AND RSD.ROLE_ID            =UD.ROLEID
            AND RM.ROLE_ID             =UD.ROLEID
            AND DSM.DEPT_SUBID         =REPTD.STABID
            AND RRDSM.DEPT_SUBID=DSM.DEPT_SUBID
            AND RM.ROLE_ID      =RRDSM.ROLEID
            AND RSD.REPORTID=REPTD.REPID
            AND DRP.REPID   =REPTD.REPID
            AND DRP.RSTATUS LIKE ‘C’
            AND TRUNC(SYSDATE) =
TRUNC(DRP.ENDTIME)
          )
        AND AA.REPID=AB.REPID
        ORDER BY
          AB.ENDTIME DESC
      )
  );

<<SQL
Begins>>



By
Karkuvelraja T
  • January 2, 2017 | 16 views
  • Comments