1 Reply Latest reply: Apr 21, 2014 10:36 AM by TexasApexDeveloper RSS

    APEX Help guide link in application

    971280

      I have a .pdf help document that I would like to open or go to when a user clicks on the Help Tab.  What is the easiest way to do this?  I tried adding a Page with Help Text, but would just like be able to link to the .pdf document.  I am using APEX 4.2

      Thank you.

        • 1. Re: APEX Help guide link in application
          TexasApexDeveloper

          Is the Help tab a literal tab in your application or a button/link in your application?  What I have done is in the Navigation bar entries of an application, I have added a link to a page for my help pdf to be displayed.

           

          I define that page with the following properties:

          I have a region that displays the pdf file (Display User Manual):

          Type: html text

          region source:

           

          <object data="f?p=&APP_ID.:&APP_PAGE_ID.:&APP_SESSION.:APPLICATION_PROCESS=VIEW_PDF" type="application/pdf" width="100%" height="100%">

            <p>It appears you don't have a PDF plugin for this browser.</p>

          </object>

           

          Ajax Callback: View_Pdf

          Process point: On Demand Run this process when requested by AJAX

          Source:

           

          DECLARE

          v_mime VARCHAR2 (48);

          v_length NUMBER;

          v_file_name VARCHAR2 (2000);

          v_lob_content BLOB;

           

          BEGIN

              SELECT mime_type,

                     blob_content,

                     DBMS_LOB.getlength (blob_content)

                INTO v_mime,

                     v_lob_content,

                     v_length

              FROM CUBE_APP_HELP;

           

              OWA_UTIL.mime_header (NVL (v_mime, 'application/pdf'), FALSE);

              HTP.p ('Content-length: ' || v_length);

              OWA_UTIL.http_header_close;

              WPG_DOCLOAD.download_file (v_lob_content);

           

          END;

           

          I also have a special page template:

           

          Definition:

          Header:

          <!doctype html>

          <html lang="&BROWSER_LANGUAGE.">

          <head>

          #HEAD#

          #TEMPLATE_CSS#

          </head>

          <body>

          #FORM_OPEN#

           

          Body:

          #REGION_POSITION_07#

          #BOX_BODY#

           

          Footer:

          #FORM_CLOSE#

          </body>

          </html>

           

          Cascading Style Sheet:

          Inline:

           

          html {

              height: 100%;

          }

          body, form {

              height: 100%;

              margin: 0;

              padding: 0;

          }

          p {

              padding: 1em;

          }

          object {

              display: block;

          }

           

          (This was provided to me by another member of the APEX community <Jari>)

           

          Thank you,

           

          Tony Miller
          LuvMuffin Software
          Ruckersville, VA