Visual Builder

Get Involved. Join the Conversation.

Posts

  • Mohamed Ibrahim
    Select one LOV return Limited number of result1
    Topic posted December 6, 2019 by Mohamed Ibrahim, tagged Layout, REST, UI 
    Title:
    Select one LOV return Limited number of result
    Summary:
    I have a list of value that get thousands of data from SaaS but only 15 values appear how to get popup search to get limited by my search criteria
    Content:

    I have a list of value that get thousands of data from SaaS but only 15 values appear how to get popup search to get limited by my search criteria.

  • Rahul L
    Capture values in comma separated, selected from Select...1
    Topic posted December 5, 2019 by Rahul LGreen Ribbon: 100+ Points, tagged Composite Component, Custom Code, Database, JET, Layout, Style, UI, Validation 
    Title:
    Capture values in comma separated, selected from Select Many Component
    Content:
    Hi, I am using a Select Many Component to select multiple values from LOV listed from Rest. Now i wanted to store the selected values in custom table with comma separated values. Can someone please help me with this. Thanks Rahul
  • Nagesh Manda
    VBCS Application for a Jewellery retailer
    Topic posted December 2, 2019 by Nagesh MandaGold Medal: 3,500+ Points, tagged JET, Layout, Style, UI, Web 
    Title:
    VBCS Application for a Jewellery retailer
    Content:

    Hi All,

    I am in the process of designing an VBCS application to enable customers buy jewellery items and looking for some guidance around designing the UI's.

    Could you kindly let me know if there are sample applications available or design principles which i can reuse or adopt.

    Thanks,

    Nagesh.

  • Nazeer Anantha
    Conditional Mapping in Rest API URL ParamsAnswered3
    Topic posted November 28, 2019 by Nazeer AnanthaBlue Ribbon: 750+ Points, tagged Layout, REST, Services, UI, Validation, Web 
    Title:
    Conditional Mapping in Rest API URL Params
    Summary:
    Conditional Mapping in VBCS
    Content:

    Hi Team,

    I am trying to pass the conditional value in REST API URL Params Mapping.

    Can you please let me know how can I achieve this or provide syntax.

    below is the condition, which I am trying to achieve.

    if($page.variables.ChequeNumber == "undefined")
    {
      "{checkno}"
    }else{
      $page.variables.ChequeNumber
    }

     

    attaching the screenshot for more info.

    Thanks,

    Nazeer.

    Image:
  • Aishwarya Sharma
    Horizontal Scrollbar of ojtable is hidden when the specified...
    Topic posted November 27, 2019 by Aishwarya Sharma, tagged JET, Layout, Style, UI 
    Title:
    Horizontal Scrollbar of ojtable is hidden when the specified height is reached
    Content:

    Hi ,

    I am a facing weird issue regarding scroll bar in VBCS. In the style property of ojtable, I specified the height as 500 px and width as 900 px. I am able to see horizantal scroll bar until the height of table reaches 500 px. When I inspected the page, I found the below table properties:

    element.style {

    height: 500px;

    width: 900px;

     overflow: hidden;

    }

    If I remove tick mark from overflow:hidden under inspect, I am able to see horizontal scroll bar.

    Hence, I tried giving overflow:auto or overflow:visible in style property of oj table but it didnt help. Also I tried giving overflow-x:auto in the div surrounding the table but it also didnt work out.

    I am seeing this issue in chrome and not in firefox.

    Kindly let me know if anyone has any fix for this.

    Regards,

    Aishwarya

    Version:
    VIsual Builder Version : 19.3.1.4
  • Andy May-Coates
    How to handle multiple nested collections in Visual Builder...Answered135.0
    Topic posted November 18, 2019 by Andy May-CoatesBronze Trophy: 5,000+ Points, tagged Business Objects, Layout, REST 
    Title:
    How to handle multiple nested collections in Visual Builder add-in for Excel
    Summary:
    How to handle multiple nested collections in Visual Builder add-in for Excel
    Content:

    In the Oracle Visual Builder add-in for Excel, a form-over-table layout can be used to support parent-child business object relationships e.g. supplier and supplier site.

    However, we have a REST API where there are multiple nested child collections, and properties need to be supplied at each level to be of any use. For example:-

    https://***.oraclecloud.com/fscmRestApi/resources/11.13.18.05/financialProjectPlans

    This has several nested levels of child collections, and properties from each level need to be included to bulk update a financial project plan resource assignment. For example:-

    Project level detail would come from the top level "financialProjectPlans"
    Task and resource detail would come from the next level "ResourceAssignments"
    Currency and plan amount totals come from the next level "PlanningAmounts"
    Periodic plan amounts come from the lowest level "PlanAmountDetail"

    What we really need is a table layout containing properties from all four levels above, where parent properties would simply fill down/duplicate.

    On a related note, when we import the swagger for the above service, the plugin only shows the top three levels (see image below). This seems to be the case for other REST APIs. Is this a product limitation? Is there any workaround to this either?

    Any help greatly appreciated.

    Version:
    Oracle Visual Builder Add-in for Excel 2.0.0.20643
    Image:
    Document:
  • Subramanian K V
    Downloading multiple tables from UI to CSV5
    Topic posted November 15, 2019 by Subramanian K VGreen Ribbon: 100+ Points, tagged JET, Layout, UI, Web 
    Title:
    Downloading multiple tables from UI to CSV
    Summary:
    How to download multiple tables in a single cvs
    Content:

    Hi All,

    I have requirement to download multiple table data into CVS. The table structure is as below,

    One Parent table.

    5 child tables available in under "TABS WITH CONTENT" and another child table next to the parent one.

    Additionally one more child table but not available in the UI.

    Totally 7 tables(6 visible in the UI & 1 not available in UI but child records present in the respective BO)  

     

    The child tables will be refreshed when I toggle between Parent table records. So in a button action, I need to get the current parent and its child related data as separate tables, 7 child tables and one table with one row which should have the selected parent record information. All these in single csv file.

    Experts please provide your inputs.

    Regards

    Subramanian.K.V

     

     

    Version:
    19.3.1.4
  • Abhilasha Singh
    How to get an hour glass moving something similar that...6
    Topic posted November 13, 2019 by Abhilasha SinghRed Ribbon: 250+ Points, tagged JET, Layout 
    Title:
    How to get an hour glass moving something similar that indicates that the application is waiting for search results
    Summary:
    How to get an hour glass moving something similar that indicates that the application is waiting for search results
    Content:

    How to get an hour glass moving something similar that indicates that the application is waiting for search results. right now is vbcs if I enter a value in a field it call a REST service and gets the result. meanwhile the screen looks like it is not doing anything. can we have an hour glass or similar icon to indicate that something is happening in the background.

    Appreciate your help

  • Venkata P
    How to update a text area using a Pop Up5
    Topic posted November 12, 2019 by Venkata PGreen Ribbon: 100+ Points, tagged JET, Layout, UI 
    Title:
    How to update a text area using a Pop Up
    Summary:
    On clicking on text area a pop up should come up and update it
    Content:

    Hi All,

    Requirement : I have a table where the last column is a text area where user can enter some free text which can be more than 2 lines. But to have a better user experience we taught of opening a pop up on clicking of text area with a free text area and upon submission it should simply update it in the table text area column.

    I broke this task into below subtasks

    1. OnClick event open a dialog box -> No issues

    2. In the dialog box have a text area which is large enough -> No issues

    3. On clicking submitting text should update back to the table text box -> No sure how to update it to a particular it was clicked. -> Need help here.  

    Regards,

    Venkat P

    Version:
    19.3.1.2
  • Venkata P
    Dialog box is auto closing and not opening againAnswered2
    Topic posted October 26, 2019 by Venkata PGreen Ribbon: 100+ Points, tagged JET, Layout, UI, Web 
    Title:
    Dialog box is auto closing and not opening again
    Summary:
    Page has a dialog box which opens on click of button and closing automatically
    Content:

    Hi All,

    My page has a dialogbox which opens on click of button. First it opens as expected. When you click on the button again it auto closes and never opens again.

    Could you let me know what went wrong here. Below is html code and and java script.

    HTML Code :

            <div id="dialogWrapper">
              <oj-dialog style="display:none" id="modalDialog1" title="Modal Dialog">
                <div slot="body">
                   The dialog window can be moved, resized and closed with the 'x' icon.
                   Arbitrary content can be added to the the body and footer sections.
                </div>
                <div slot="footer">
                  <oj-button id="okButton" data-bind="click: function() {
                      document.querySelector('#modalDialog1').close();
                    }">  OK
                  </oj-button>
                </div>
              </oj-dialog>
              <oj-button id="buttonOpener" data-bind="click: function() {
                  document.querySelector('#modalDialog1').open();
                }">
                Open Modal Dialog
              </oj-button>
            </div>

    Java Script:

    define([], function() {
      'use strict';

      var PageModule = function PageModule() {};

      return PageModule;
    });

     

     

    Version:
    19.3.1.2
    Image:
    Code Snippet: