1 Reply Latest reply on Apr 1, 2019 4:18 PM by fac586

    HOW TO PASS A VARIABLE FROM APX URL TO APEX REPORT

    Kstore

      HELLO ...

       

      I WANT TO PASS A VARIABLE FROM THE APEX URL

      TO A REPORT INTO APEX ..

       

      EXPLAIN

       

      http://servername:8080/apex/f?p=10000:1:1:VAR_CODICE_USER=MARC

       

      AND USE THE VARIABLE  VAR_CODICE_USER

      INTO A QUESRY OF AN APEX REPORT

       

      SELECT * FROM TAB

      WHERE CODICE_USER = :VAR_CODICE_USER

       

      WHAT IS THE EXACT SYNTAX ??

       

      THANK YOU !!!

        • 1. Re: HOW TO PASS A VARIABLE FROM APX URL TO APEX REPORT
          fac586

          Kstore wrote:

           

          I WANT TO PASS A VARIABLE FROM THE APEX URL

          TO A REPORT INTO APEX ..

           

          EXPLAIN

           

          http://servername:8080/apex/f?p=10000:1:1:VAR_CODICE_USER=MARC

           

          AND USE THE VARIABLE VAR_CODICE_USER

          INTO A QUESRY OF AN APEX REPORT

           

          SELECT * FROM TAB

          WHERE CODICE_USER = :VAR_CODICE_USER

           

          WHAT IS THE EXACT SYNTAX ??

          Please do not SHOUT.

           

          Note that APEX has application and page items, not variables. These items must have been defined in the application or page before they can be referenced in URLs or region source code.

           

          The use of URLs to link APEX applications and pages is comprehensively described in the documentation. The APEX parameters in the URL take the form:

           

          f?p=App:Page:Session:Request:Debug:ClearCache:itemNames:itemValues:PrinterFriendly

           

          To set application and page item values via the URL, include a comma-separated list of item names in the itemNames position, and a comma-separated list of the corresponding values in the itemValues position. If a data value may contain commas or colons, it must be escaped using backslashes ("\"):

           

          f?p=10000:1:0::::APP_ITEM,P1_ITEM:Foo,\Lastname, Firstname\: