VBCS - task14 - Access data from an external REST service

Usecase: Here, we will see how to use visual Builder to access data from an external REST service.

So far, we have created business objects to store data in an embedded database and accessed that data through REST endpoints that were automatically created for us. But business objects are not the only option for data access, in fact, we can connect to any REST enabled data source by creating a service connection.

The create connection wizward provides following 3 options to connect REST endpoints:

1. Select from Catalog: when we have access to an oracle cloud applications or oracle integration instance. We can use the seelct from catalog option to access endpoints exposed by these oracle services.

https://soalicious.blogspot.com/2022/05/vbcs-call-oic-integration-from-visual.html

2. Define by Specification: when we have access to a swagger or oracle ADF file that describes a service.

3. Define by Endpoint: when we know the URL of an external REST endpoint.

https://soalicious.blogspot.com/2024/04/vbcs-task15-access-data-from-external.html

VBCS - task13 - change the app's deafult page

 Usecase: Here, we will change the application's deafult home page from departments to employees.

Web apps >> click main node >> click settings >> set default page

VBCS - task12 - add a button to delete a department

 Usecase: Here we will add a button to delete a department row using quick start.

Select the main-departments page in web apps >> click the page designer tab >> select table >> clcik quick start in table's properties pane >> click add delete action >>select department under business objects>> finish >> delete department button is added in the toolbar on the main-departments page >> go to preview >> select a department row and click delete department and save

VBCS - task11 - add a page to edit business object like department's details

 Here, we will add an edit page that lets user to change a department's name and location 

Select the main-departments page in web apps >> click the page designer tab >> select table >> clcik quick start in table's properties pane >> add edit page >>select delartment and location >> finish >> edit department button is added in the toolbar on the main-departments page >> go to preview >> select a department tow and click edit department and save.

VBCS - task10 - Add navigation between pages in a webapp | Action chain

Here, we will see how to setup navigation between pages in a web app.

We can do this by addig buttons that perfom specific actions when we click then. This sequence of actions is called an action chain in visual builder. 

Usecase: create an action chain to navigate from departments page to employees page:

Click web applications >> click main-departments page >> select button from component pallet and drop to the page beside create department  >>click button and change level field to Show Employees >> go to events tab and click + event listener >> select on 'ojAction' >> an empty action chain will open >> drag "Navigate to Page" action and drop to the canvas and select the page >> click preview and test.

VBCS - task9 - change the name of the main-start page

 Here, we will change the name of the main-start page.

Webapps >> right click on main-start >> select rename >> provide new name >> click on main node >> you can see page name changed but its still default page.

We can also go to source tab and check the main nodes >> main-flow.json

VBCS - task8 - Add a page to create employees

 Here we will add a page to create employees using quick start.

Select table component within the panel on the main-employees page >> click Quick start >> add create page >> add all the fields with required types >> click the structure view >>select the form layout >> set the cloumns value to 2  >> click live and test

When we click the code, we can see the html code for title, the table, the div elements etc. The components , classes all begin with oj- , indicates that they are Oracle Javascript Extension Tollkit(JET) components.