Editing Business Objects in Oracle Visual Builder Cloud Service

In the Page Designer, you can use the Data palette to add a field to a business object. You can then add the new field to business component pages as an input or output component.

Another way to do things, instead of adding a field to a business object, is to add an input component to a page of the business object (such as the Create page). That way, the new input component is automatically added as a field to the business object.

Adding a Field to a Business Object Using the Data Palette

In this section, you'll use the Data palette to add a Job list-of-values field to the Employee business object.

1. In the web browser, log in to Oracle Visual Builder Cloud Service.

2. On the Home page, click HR Application 1.0.

   

3. Click the Data palette.

   

4. In the Business Object list, select Employee.

   

5. Click + New Field.

   

6. In the pop-up box, enter the following:

   • Default Display Label: Job

   • Field Data Type: Lookup

   • Field ID: ref2Job (automatically populated)

   • Lookup Object: If necessary, select Create New, and enter Jobs in the Lookup Label text field.

   

7. Click Define Lookup Values.

   

8. Click + Add Lookup Value six times and enter the following values one by one:

   • President

   • Vice President

   • Finance Manager

   • Accountant

   • Programmer

   • Resources Representative

   

   If you make a mistake, you can click the icon in the row to remove the value, or drag the icon to change the order.

   Once a lookup value is added and saved, it cannot be deleted. However, you can use the Data Designer to add more fields or make a field inactive.

9. Click the  icon.

   The Data palette shows the new Job field.

   

Adding the New Field to a Page

After adding the Job field to the Employee business object, add the field to the Employee business object pages.

When you add a field to a business object page, you can drag and drop the field from the Data palette onto the page and choose the component type. Alternatively, you can drag and drop a component from the Components palette onto the page and then choose the business object field name.

1. Open the page menu and select Create Employee.

2. Select the Job field in the Data palette and drag and drop it onto the Create Employee page below the Department field.

   

3. In the Component pop-up box, select Output Combo Box.

   

   The Create Employee page should look like this.

   

4. Open the page menu and select Edit Employee.

5. Click the Components palette, then drag and drop the Combo Box component onto the Edit Employee page below the Department field.

   

6. In the pop-up box, enter the following:

   • Business Object Field:  Click the Existing toggle button

   • Field ID: Select ref2Job from the drop-down list

   • Label: Job (automatically populated)

   • Business Object: Employee (automatically populated)

   • Field Data Type: Lookup (automatically populated)

   

   Click the icon to save the details.

7. Open the page menu and select Employees.

8. Select the Employees table component.

   

9. In the Table Properties pane, click the Data tab.

   

10. Click the icon next to Table Columns.

    

11. In the Select Table Columns dialog box, drag and drop the Job field into Table Columns and click Done.

    

12. Verify that the Job column has been added to the Employees table.

    

    As there is no data for the Job field, the column is empty. Don't enter any data now. You'll import data from CSV files later in this tutorial.

T2_2 In this section, you'll create the Address field in the Employee business object. Instead of using the Data palette to create a field, you'll drag and drop a Text Area component from the Components palette onto the Create Employee and Edit Employee pages.

1. Open the page menu and select Create Employee.

2. From the Components palette, drag and drop the Text Area component onto the Create Employee page below the Two-Column component.

   

3. In the pop-up box, enter the following:

   • Label: Address

   • Business Object: Employee (selected by default)

   • Business Object Field: New (selected by default)

   • Field ID: address(automatically populated)

   • Field Data Type: Text (selected by default)

   

   Click the icon to save the details.

4. Drag the left and right widths of the text area field, as needed, to adjust it to 100%.

   

5. Click the Properties tab and, for the Text Area properties, enter the following:

   • Label Position: Select Top.

   • Placeholder: Employee Address

   • Number of Rows: 2

   

6. Click the Style tab.

   

7. Set the Label Alignment to Left.

   

8. Click the Data palette and see the Address field added to the list of fields.

   

9. Open the page menu and select Edit Employee.

10. Open the Component palette and drag and drop the Text Area component onto the Edit Employee page below the Two-Column component.

    

11. In the pop-up box, enter the following:

    • Business Object Field: Existing

    • Field ID: address

    • Label: Address (automatically populated)

    • Business Object: Employee (selected by default)

    • Field Data Type: Text (selected by default)

    

    Click the icon to save the details.

12. Click the Properties tab and edit the Text Area properties (Label Position, Placeholder, and Number of Rows) as you did in the Add Employee page. Drag the left and right widths of the text area field, as needed, to adjust it to 100%. Click the Style tab and set the Label Alignment to Left.

    The Edit Employee page should look like this.

    

13. Open the page menu and select Employees.

14. Select the Employees table.

    

15. In the Table Properties pane, click the Data tab.

    

16. Click the icon next to Table Columns.

    

17. Drag and drop the Address field into Table Columns and click Done.

    

18. Verify that the Address column has been added to the Employees table.