Visual Builder

Get Involved. Join the Conversation.

Comments

  • Preetesh Dongre

    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

    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

    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

    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

    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

    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

    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
    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

    Hi John,

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

  • Alex Davis

    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

    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

    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

    Thanks for your input Shay!!

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

  • Shay Shmeltzer

    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

    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)