Visual Builder

Get Involved. Join the Conversation.

Posts

  • Rahul L
    Capture values in comma separated, selected from Select...
    Topic posted 12:36 PM 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.

  • 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
  • Stiven Oliveira Bezerra
    Offline Post VBCS with Business Object115.0
    Topic posted November 25, 2019 by Stiven Oliveira BezerraBlue Ribbon: 750+ Points, tagged Business Objects, JET, Mobile, REST 
    Title:
    Offline Post VBCS with Business Object
    Content:

    Hi i need to do a Get and Post with offline service, i follow some steps for this post here, https://blogs.oracle.com/shay/adding-offline-capabilities-to-an-oracle-visual-builder-app. But my Post doesn't work, and i'm try to do this for Mobile VBCS. This my code: 

    define([
        'vbsw/helpers/serviceWorkerHelpers',
        'persist/persistenceManager',
        'persist/defaultResponseProxy',
        'persist/persistenceUtils',
        'persist/fetchStrategies',
        'persist/impl/logger'
      ],
      function(ServiceWorkerHelpers, PersistenceManager, DefaultResponseProxy,
        PersistenceUtils, FetchStrategies, Logger) {
        'use strict';

        function AppModule() {}

        function OfflineHandler() {

          Logger.option('level', Logger.LEVEL_LOG);
          Logger.option('writer', console);

          var options = {

            requestHandlerOverride: {
              handlePost: handlePost
            },
            fetchStrategy: FetchStrategies.getCacheIfOfflineStrategy({
              backgroundFetch: 'disabled'
            })
          };
          this._responseProxy = DefaultResponseProxy.getResponseProxy(options);
        }

        OfflineHandler.prototype.handleRequest = function(request, scope) {

          console.log('OfflineHandler.handleRequest() url = ' + request.url +
            ' cache = ' + request.cache +
            ' mode = ' + request.mode);

          if (request.url.match(
              'https://devpoc-timtoa.integration.ocp.oraclecloud.com:443/ic/builder/design/yb/1.2.1/resources/data/ServiceOrderLineReview'
            )) {

            return this._responseProxy.processRequest(request);
          }
          return PersistenceManager.browserFetch(request);
        };

        OfflineHandler.prototype.beforeSyncRequestListener = function(event) {
          return Promise.resolve();
        };
        OfflineHandler.prototype.afterSyncRequestListener = function(event) {
          return Promise.resolve();
        };
        AppModule.prototype.createOfflineHandler = function() {
          return Promise.resolve(new OfflineHandler());
        };
        AppModule.prototype.isOnline = function() {
          return ServiceWorkerHelpers.isOnline();
        };
        AppModule.prototype.forceOffline = function(flag) {
          return ServiceWorkerHelpers.forceOffline(flag).then(function() {
        
            if (!flag) {
              return ServiceWorkerHelpers.syncOfflineData();
            }
            return Promise.resolve();

          }).catch(function(error) {
            console.error(error);
          });
        };
        AppModule.prototype.dataSynch = function() {
          return ServiceWorkerHelpers.syncOfflineData();
        };

        // custom implementation to handle the POST request
        var handlePost = function(request) {
          if (ServiceWorkerHelpers.isOnline()) {}

          return PersistenceUtils.requestToJSON(request).then(function(
            requestData) {
            console.log('Inside PersistenceUtils');
            console.log(requestData);
            requestData.status = 202;
            requestData.statusText = 'OK';
            requestData.headers['content-type'] = 'application/json';
            requestData.headers['x-oracle-jscpt-cache-expiration-date'] =
              '';

            // if the request contains an ETag then we have to generate a new one
            var ifMatch = requestData.headers['if-match'];
            var ifNoneMatch = requestData.headers['if-none-match'];

            if (ifMatch || ifNoneMatch) {
              var randomInt = Math.floor(Math.random() * 1000000);
              requestData.headers['etag'] = (Date.now() + randomInt).toString();
              requestData.headers['x-oracle-jscpt-etag-generated'] =
                requestData.headers['etag'];
              delete requestData.headers['if-match'];
              delete requestData.headers['if-none-match'];
            }
            return PersistenceUtils.responseFromJSON(requestData);
          });
        };

        AppModule.prototype.hideSpinner = function() {
          // tear down the spinner screen
          var spinner = document.getElementById('vb-spinner');
          if (spinner) {
            // if the spinner screen is not yet displayed, immediately remove it and return
            var computedStyle = window.getComputedStyle(spinner);
            var opacity = parseInt(computedStyle.getPropertyValue('opacity'),
              10);
            if (opacity < 0.1) {
              spinner.parentNode.removeChild(spinner);
              return;
            }

            var transEndFn = function() {
              if (spinner.parentNode) {
                spinner.parentNode.removeChild(spinner);
              }
              spinner.removeEventListener('transitionend', transEndFn);
            };
            spinner.addEventListener('transitionend', transEndFn, false);
            spinner.className += ' vb-spinner-reveal-trans';
          }
        };

        return AppModule;
      });

     

    Have something wrong? I need more things to work in Mobile? I'm using the Business Object.

  • Vishnu Mishra
    Using Radio Buttons to Select a Single Row
    Topic posted November 22, 2019 by Vishnu MishraRed Ribbon: 250+ Points, tagged JET 
    Title:
    Using Radio Buttons to Select a Single Row
    Summary:
    Using Radio Buttons to Select a Single Row
    Content:

    Hi,

    I have a requirement where I have to select a single row in table. I know this can be easily done using the Selection Mode property of the oj-table. However, what I want is to enable selection only when a radio button is clicked on the row. For this, I tried using Radio Button Set, but it doesn't provide a unique set across the rows, that is, selecting one button on one row doesn't deselect other button on other rows.

    I have watched this video: https://blogs.oracle.com/shay/using-checkbox-to-select-rows-in-a-table-in-visual-builder but it doesn't seem conducive to what I want to achieve. Also, I am using an SDP. Any idea how can I achieve this?

    Regards,
    Vishnu

  • Abhilasha Singh
    How to freeze first 3-4 columns in table and have scroll bar...1
    Topic posted November 20, 2019 by Abhilasha SinghRed Ribbon: 250+ Points, tagged Custom Code, JET, UI 
    Title:
    How to freeze first 3-4 columns in table and have scroll bar after that
    Summary:
    freeze first few columns of a table and have a scroll bar after that
    Content:

    I have a requirement to freeze first 3-4 columns of a table on the page and have a scroll bar starting from 5th column. I saw a table property to start the scroll bar at specific position but that doesn't freeze the previous columns. 

    Your inputs are greatly appreciated!

    Thanks,

    Abhilasha

  • 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
  • vijay.kekane
    Display name instead of ID on main-start page1
    Topic posted November 1, 2019 by vijay.kekane Red Ribbon: 250+ Points, tagged Business Objects, JET, REST, UI 
    Title:
    Display name instead of ID on main-start page
    Summary:
    Display name instead of ID
    Content:

    Hi There,

    I have application with 3 pages, Main-Start, Main-Create, Main-Edit. Main-start is first page displayed when application is run. Data is created/saved using create page. Field "ledger" is shown on both pages. We use LOV for it, which show name but, store ID in VBCS BO.

    When application run it shows list of rows in main page (image of start-main is attached) using VBCS BO, We want to display name of ledger instead of ID.

    I am not sure which page level event will allow me to scan through each record to find name based on ID (using REST) and display name on Main-Start page.

    Thanks,

    Vijay

     

    Version:
    19.3.1.2
    Image: