Application Developmentpublic

Visual Builder

Get Involved. Join the Conversation.

This is a public Forum  public

Comments

  • Preetesh Dongre
    Preetesh Dongre on Unable to start process from VBCS button action chain

    Hi Rob,

    Go to Processes -> Process , under 'Allow the application to use test instances during development?' check the option to 'Allow Test Instances' with Runtime option and retry.

    Regards,

    Preetesh

  • David Konecny
    David Konecny on Simple POST: Getting Bad Request

    If you disable VB Proxy (in Auth section) does it work? Could you append please also Request/Response headers (can be found in CHrome Network Monitor) on failed request. Thx

    -David

  • David Konecny
    David Konecny on QR Reader Issue

    Solved offline. The solution attached FYI.
    -David
     

    • custom event has to have payload defined:

      "events": {
    "DisplayResultsEvent": {
      "payloadType": {
        "qrCode": "string"
      }
    }
  }

    • custom JS code needs to fire custom event using payload defined above, that is:

    this.eventHelper.fireCustomEvent("DisplayResultsEvent", { "qrCode" : "david12434" });

    • custom event listener needs to either pass whole payload object into chain or just one handpick property, eg.:

        "DisplayResultsEvent": {
      "chains": [
        {
          "chainId": "qrCodeScannedListener",
          "parameters": {
            "qrCode": "{{ $event.qrCode }}"
          }
        }
      ]
    }

    • chain needs to have correct param defined as input+required:

        "qrCodeScannedListener": {
      "variables": {
        "qrCode": {
          "type": "string",
          "required": true,
          "input": "fromCaller"
        }
      },
  • Ziv Rubin
    Ziv Rubin on Simple POST: Getting Bad Request

    Hi Sunil,

    Here is my VBCS POST request log from the browser's developer console:

    jsnlog.js:1 vbdt/services-core/api/executor/RequestBuilder: POST https://XXXXXXXXXX:XXXXXXXXXX/fscmRestApi/resources/11.13.18.05/demandPlans/300000001781305/child/Runs/
    VM482:5030 Before fetch handler plugin
    persistenceManager.js:219 POST https://XXXXXXXXXX.integration.ocp.oraclecloud.com/ic/builder/design/XXXXXXXXXX/1.0.1/services/auth/proxy/CallRunTest/uri/https/XXXXXXXXXX/fscmRestApi/resources/11.13.18.05/demandPlans/300000001781305/child/Runs/ 400 (Bad Request)
    (anonymous) @ persistenceManager.js:219
    PersistenceManager.browserFetch @ persistenceManager.js:217
    eval @ VM482:3497
    Promise.then (async)
    fetch @ VM482:3491
    eval @ VM482:3682
    Promise.then (async)
    eval @ VM482:3680
    Promise.then (async)
    eval @ VM482:3673
    Promise.then (async)
    handleRequest @ VM482:3632
    handleRequest @ VM482:4256
    eval @ VM482:4829
    _dispatchEvent @ persistenceManager.js:278
    (anonymous) @ persistenceManager.js:476
    Promise.then (async)
    (anonymous) @ persistenceManager.js:472
    fetch @ CertificateEvents.js:2
    execute @ CertificateEvents.js:2
    invoke @ Catalog.js:2
    async function (async)
    invoke @ Catalog.js:2
    execute @ Catalog.js:2
    async function (async)
    execute @ Catalog.js:2
    sendRequest @ Catalog.js:2
    TestTabModel.sendRequest @ SourceTab.html!text:2
    domListener @ ojet.min.js:138

    I attached SS from Postman as well.

     

  • Ziv Rubin
    Ziv Rubin on Simple POST: Getting Bad Request

    Hi Sunil,

    Here is my VBCS POST request log from the browser's developer console:

    jsnlog.js:1 vbdt/services-core/api/executor/RequestBuilder: POST https://XXXXXXXXXX:XXXXXXXXXX/fscmRestApi/resources/11.13.18.05/demandPlans/300000001781305/child/Runs/
    VM482:5030 Before fetch handler plugin
    persistenceManager.js:219 POST https://XXXXXXXXXX.integration.ocp.oraclecloud.com/ic/builder/design/XXXXXXXXXX/1.0.1/services/auth/proxy/CallRunTest/uri/https/XXXXXXXXXX/fscmRestApi/resources/11.13.18.05/demandPlans/300000001781305/child/Runs/ 400 (Bad Request)
    (anonymous) @ persistenceManager.js:219
    PersistenceManager.browserFetch @ persistenceManager.js:217
    eval @ VM482:3497
    Promise.then (async)
    fetch @ VM482:3491
    eval @ VM482:3682
    Promise.then (async)
    eval @ VM482:3680
    Promise.then (async)
    eval @ VM482:3673
    Promise.then (async)
    handleRequest @ VM482:3632
    handleRequest @ VM482:4256
    eval @ VM482:4829
    _dispatchEvent @ persistenceManager.js:278
    (anonymous) @ persistenceManager.js:476
    Promise.then (async)
    (anonymous) @ persistenceManager.js:472
    fetch @ CertificateEvents.js:2
    execute @ CertificateEvents.js:2
    invoke @ Catalog.js:2
    async function (async)
    invoke @ Catalog.js:2
    execute @ Catalog.js:2
    async function (async)
    execute @ Catalog.js:2
    sendRequest @ Catalog.js:2
    TestTabModel.sendRequest @ SourceTab.html!text:2
    domListener @ ojet.min.js:138

    I attached SS from Postman as well.

     

  • Sunil Polineni
    Sunil Polineni on Simple POST: Getting Bad Request

    Can you check browser log and compare VBCS request with postman and see if you find any difference.

    Also in connection/Authentication setting can invoke using proxy and see if that makes any difference.

    Regards,

    Sunil

  • Yuandi Jin
    Yuandi Jin on List of Values in Visual Builder Excel Plug in5.0

    Hi Kashyap,

    You can find detailed info for List of Values here:

    https://docs.oracle.com/en/cloud/paas/app-builder-cloud/visual-builder-excel/using-lists-values-excel-workbook.html

    The search expression is used on the referenced business object (i.e. the business object that provides the display values, not the business object of current table).

     

    If I understand your question correctly, you are trying to filter the List of Values based on another field in the table.

    Say you have column D with label "ID" and column E with label "Banana". Column E has List of Values but you want to filter the list using a value in column D. You want to know how to do that.

    Is that correct?

     

    Regards,
    Yuandi

  • Shay Shmeltzer
    Shay Shmeltzer on Select one LOV return Limited number of result
    That's intentional, you can start typing and it will search over all the records. You can choose another approach to get all the records as shown here https://blogs.oracle.com/shay/tips-and-tricks-for-list-of-values-in-visual-builder-cloud-service
  • Sweta Singh
    Sweta Singh on Images imported in appn are reflecting in Chrome but not in...

    Hi John,

    Its working fine now. Some extra class was overriding in Edge & IE on removing it got fixed. Thankyou.

  • Alex Davis
    Alex Davis on Insert data to database using VBCS excel Plugin

    You can use a variety of REST services with the Excel add-in.

    Be sure to grab the latest version here: https://www.oracle.com/downloads/cloud/visual-builder-addin-downloads.html

    ...and review the guide here: https://docs.oracle.com/en/cloud/paas/app-builder-cloud/visual-builder-excel/toc.htm

    In particular, check out chapter 11 on REST service support.

    > Can I also hookup REST enabled pl/sql procedure in the VBCS excel?

    Probably not. But, what does the API look like? Do you have a sample to share?

  • Sweta Singh
    Sweta Singh on Images imported in appn are reflecting in Chrome but not in...

    Yes John, Tried taking images from application-path & flow-path both. But both are not working.

    Image Url i have given in same way as below:-

    :src="{{ $flow.path + 'resources/images/icon_Gray_Plus-Expand.png'}}"

    :src="{{ $application.path + 'resources/images/button_Search.png' }}"

    But main problem is the images folder itself is not coming up in source structure in browser console for Edge as shown in the picture.

  • John Ceccarelli
    John Ceccarelli on Images imported in appn are reflecting in Chrome but not in...

    if you're putting them in the resources folder then the path should be  $application.path + "/resources/images". Did you create a new resources folder under the flow?

  • Digvijay Chauhan
    Digvijay Chauhan on Insert data to database using VBCS excel Plugin

    Thanks for your input Shay!!

    Can I also hookup REST enabled pl/sql procedure in the VBCS excel?

  • Shay Shmeltzer
    Shay Shmeltzer on Log files In VBCS

    I don’t believe we are directly exposing our server logs right now.

    What info would you be interested to gain from those logs?

     

  • Shay Shmeltzer
    Shay Shmeltzer on Insert data to database using VBCS excel Plugin

    You can REST enable your table with ORDS and then hookup the VB Excel plugin to it.

    See https://www.thatjeffsmith.com/archive/2019/04/linking-excel-to-auto-rest-enabled-tables-with-the-oracle-visual-builder-plugin/

    (or if you prefer working in Java you’ll be able to take a similar approach using ADF business objects as the REST enabling layer)

Change View

Sort

community forum