0 Replies Latest reply on Feb 12, 2019 3:45 PM by Leo Stalder

    Web Source Modules and Interactive Report

    Leo Stalder

      Hi everyone

       

      I have a Web Source Module, which collects data from an already existing Oracle REST API, configured over the ORDS in the SQL Developer.

      The handler returns static 10 rows.

      Query:

      select sb.TABELLE, sf.FELD, sf.FELDPROMPT, sf.FELDWERT, sb.DATUMZEIT, sb.MODULNAME

      from scopebasis sb

      inner join scopefeld sf on sb.zeilenr = sf.zeilenrscb

      where sb.benutzer = :mitarbnr

      order by sb.datumzeit desc

      FETCH FIRST 10 ROWS ONLY;

       

      Response:

      {

          "items": [

              {

                  "tabelle": "MODULTOSCA",

                  "feld": "TOSCAICON",

                  "feldprompt": "Icon",

                  "feldwert": "einkauf",

                  "feldwert_bez": null,

                  "datumzeit": "2019-02-12T12:03:11Z",

                  "modulname": "M720"

              },

              {

                  "tabelle": "MODULTOSCA",

                  "feld": "APPL",

                  "feldprompt": "Applikation",

                  "feldwert": "E",

                  "feldwert_bez": null,

                  "datumzeit": "2019-02-12T12:02:49Z",

                  "modulname": "M720"

              },

              {

                  "tabelle": "MODULTOSCA",

                  "feld": "TOSCAICON",

                  "feldprompt": "Icon",

                  "feldwert": "einkauf",

                  "feldwert_bez": null,

                  "datumzeit": "2019-02-12T12:02:49Z",

                  "modulname": "M720"

              },

              {

                  "tabelle": "MODULTOSCA",

                  "feld": "MODULNAME",

                  "feldprompt": "Kurzname",

                  "feldwert": "E235",

                  "feldwert_bez": "drucken Lieferanten-Mahnungen",

                  "datumzeit": "2019-02-12T12:02:49Z",

                  "modulname": "M720"

              },

              {

                  "tabelle": "MODULSPRUNG",

                  "feld": "MODULNAME",

                  "feldprompt": "ist enthalten in",

                  "feldwert": "X310",

                  "feldwert_bez": null,

                  "datumzeit": "2019-02-12T12:01:26Z",

                  "modulname": "M720"

              },

              {

                  "tabelle": "MODULSPRUNG",

                  "feld": "MODULNAME",

                  "feldprompt": "ist enthalten in",

                  "feldwert": "S300",

                  "feldwert_bez": null,

                  "datumzeit": "2019-02-12T12:01:25Z",

                  "modulname": "M720"

              },

              {

                  "tabelle": "MODULAUSFUEHRUNG",

                  "feld": "DRUCKPROZESSID",

                  "feldprompt": "ID des Jobs",

                  "feldwert": "194328",

                  "feldwert_bez": null,

                  "datumzeit": "2019-02-12T09:15:52Z",

                  "modulname": "M782"

              },

              {

                  "tabelle": "MODULAUSFUEHRUNG",

                  "feld": "KSTKTR",

                  "feldprompt": "Firmanr",

                  "feldwert": "444",

                  "feldwert_bez": null,

                  "datumzeit": "2019-02-12T09:15:52Z",

                  "modulname": "M782"

              },

              {

                  "tabelle": "MODULAUSFUEHRUNG",

                  "feld": "MODULNAME",

                  "feldprompt": "interne Kurzbezeichnung des Moduls",

                  "feldwert": "E235",

                  "feldwert_bez": null,

                  "datumzeit": "2019-02-12T09:15:52Z",

                  "modulname": "M782"

              },

              {

                  "tabelle": "MODULAUSFUEHRUNG",

                  "feld": "SPRACHE",

                  "feldprompt": "Sprache",

                  "feldwert": "D",

                  "feldwert_bez": null,

                  "datumzeit": "2019-02-12T09:15:52Z",

                  "modulname": "M782"

              }

          ]

      }

       

      The Report does now following:

      He executes the request endless times and just list the responses  among each other...

      How can I stop him from doing that?

       

      Second question:

      The Report always adds a "?limit=51"in the end of every Request... I don't want that actually, we have our own logic to do the pagination.

       

      I would be super grateful for everything what brings me a bit forward...

      Thanks and best regards

      Leo