View and Edit Data in Business Objects

You can use the Data tab to view the data associated with your business objects in any of your databases (Development, Staging, and Live).

To view the data in a business object:

  1. Select the business object that you want to view and open the Data tab.
    The table in the Data tab uses columns to display the data stored in the business object's fields. The table displays the data for editable and read-only fields.
  2. To sort data in a column, click the column's header arrows, or expand the Query node and enter search criteria to display only the rows that meet your criteria.

Edit the Data in Business Objects

You can directly edit business object data stored in your databases, by using a business object's Data tab to modify, export, and import the data.

The Data tab displays a table with the data for each of the business objects in your application. You can add data by creating new rows and adding data to the fields in business objects. Use the tools in the toolbar to perform the following functions:

  • For business objects marked as containing application setup data, reload setup data from application sources
  • Import a CSV file or Excel spreadsheet (.xls or .xlsx) to replace or append data
  • Export the entire table as a CSV file
  • Refresh the data display
  • Select the fields to be displayed (by default, only the Id field and user-created fields are displayed)
  • Edit the data stored in the editable fields of an object by editing individual rows
  • Delete a row
  • Duplicate a row
To edit the data in a single row:
  1. Select the business object you want to edit and open the Data tab.
    The table in the Data tab displays the data stored in the business object's fields.
  2. Select the row that you want to edit and click the Edit Row icon in the table toolbar to open the Edit Row dialog.
    Description of bo-data-edit-row.png follows
    Description of the illustration bo-data-edit-row.png
    The Edit Row dialog displays the editable fields in the business object and the current data stored in the selected record. Some fields, such as the creation date, are populated automatically and are not displayed in the edit dialog.
  3. Make your changes in the dialog. Click Save.
    The validation rules for fields are enforced when you edit the data stored in the records.

Import Data to a Business Object

You can edit the data stored in a business object by importing a CSV file or an Excel spreadsheet (XLS or XLSX). When you import the file, you can choose to replace all the current data or add the data in the file as new rows to your existing data.

Use this import option to update the data in a particular business object. To simultaneously update the data for one or more business objects, you can import data from the Data Manager (see Work with the Data Manager).

To import data to a business object:

  1. Open the Data tab of the business object that you want to edit.
    The table in the Data tab displays the data stored in the fields of the business object.
  2. Click Import From File in the toolbar.
    The Import Data dialog provides options to either replace the existing data or to append the data in the file to the existing data.
    Description of bo-data-import.png follows
    Description of the illustration bo-data-import.png

    When you append the data from a file, the IDs for the new data are renumbered to prevent duplicating IDs.

  3. Upload the file by browsing your local file system or by dragging the file into the dialog box.
  4. Select Append or Replace in the dialog box. Click Import.
  5. Click OK.

Reload Data from Application Sources

For business objects marked as application setup data, if your development database schema does not show the most up-to-date data (say, because the object's data was updated as part of a Git merge), you'll need to reload data from the application's sources.

When a business object is identified as containing application setup data, its data is considered application metadata and is stored in the entity-data.csv file as part of the application's sources. Any time you update the object's data, either by editing it directly in the Data tab or by importing files through the Data Manager, your updates take effect in the entity-data.csv file and reflect automatically in your development database schema. Sometimes though, if this data is updated as part of a Git merge when your visual application is integrated with a Git repository, your database might not show those updates. This can happen when two users update data on their own Git branches and then merge those updates to the default branch (main, for example), or even when you switch branches in your Git repository. You'll then need to get these updates by reloading the entity-data.csv file from the application's sources to your database schema.

To reload data from the application's sources:

  1. Select the business object marked as containing application setup data.
  2. Click Data.
  3. Click the option to reload setup data from application sources (Reload Setup Data from Application Sources icon).
  4. After data is imported from the entity-data.csv file, click Close.
Your development database schema reflects the current version of the entity-data.csv file.