Display
As soon as you have selected an entity, the first 100 entries for this entity are displayed on the right-hand side. If there are more than 100 entries, you can load them using the button at the bottom of the table.
Add and edit
Add
To add new entries to the selected entity, use the Add icon in the top action bar.
Edit
To edit existing entries, first select them in the list and then use the Edit icon in the top action bar.
Dialog
A new dialog opens when adding and editing. All fields of the entity are displayed in this dialog. Mandatory fields are marked with an asterisk.
The dialog checks whether the entries match the selected data type in d.velop business objects. For example, you cannot save the object as long as there are letters in a number field or mandatory fields are not yet filled.
If a field has the type Guid, a symbol is displayed next to the input field, which can be used to generate a Guid.
Delete
To delete one or more entries of the selected entity, first select it in the list and then use the delete icon in the top action bar.
Refresh
To refresh the display of the entries, use the Refresh icon in the top action bar.
Delete all data records
To delete all data records of the currently selected model, use the corresponding icon in the top action bar. To confirm the action, enter the model and entity name.
Notes:
Deleting all data records is only available on models in published status
After this action, all data records of the model in the business object are irretrievably deleted
If necessary, perform an export of all data before deleting it
Search
To search through the displayed entries, use the search bar in the top action bar. Only the displayed data records are searched.
Customize columns
To customize the columns displayed in the table, use the Customize columns icon in the top action bar. In the dialog, you can simply select all columns to be displayed. (Note: The Id column is always displayed)
Sort
Click on a column to sort the table according to this property. Another click reverses the sort order. Clicking again cancels the sort order.
Importing CSV files
To import data from a CSV file, use the icon in the top action bar. The corresponding file and the separator used in the file must then be selected in the import dialog. After the import, you will receive an overview of how many data records have been imported and, if applicable, information on errors during the import.
Notes on the import:
The import of files is only available on models with the status published
An attempt is always made to import all data records in the file, even if individual data records cause errors
Multiple values must be enclosed in square brackets and are separated by a semicolon. e.g: [value 1;value 2] (If the separator is also a semicolon, the values must be escaped with quotation marks)
If data records with a specific key already exist, they will be overwritten by the import
If properties of a business object do not exist as columns in the CSV file, these are assumed to be empty and overwritten accordingly
The import requires the CSV file to be encoded in UTF-8 format
Export all data
You can export all data records of the selected model using the icon in the top action bar. In the export dialog, you can select which columns are to be exported and which separators are to be used to separate them. If a data record contains the separator, it is masked with quotation marks. The output file is encoded in UTF-8.
If the tile or widget is not available, you may not have the required authorizations. In this case, please contact your administrator.