• Description
• How to use it

Description

In this documentation you will learn how to combine several tables into one DSO. For example, you want to display the contents of two tables in a grid or form. To do this, create a new entity with a source query that combines these tables. From the table you can generate the DSO and all other objects.

How to use it

You can create objects with data from more than one table. In the default objects, objects are always created for one table only.

Prerequisite: You have already created the objects for the tables you want to join.

For example: You want to join the Customers table and the Orders table. You must first create the objects for this table by choosing Quick Builder: Automatic object generation based on your DB

1. Create custom entity with all desired fields.
1. Copy an existing, working entity and name the newly created entity properly (e.g. with all included tables).
2. In the entity instances:
1. Drag&Drop your needed data fields from the other tables to the entity, adjust the sequence if needed.
3. In the entity do the following:
1. Attribute SourceTables: Insert all the required tables comma-separated with the naming databasename.tablename,databasename.tablename.
2. Attribute SourceQuery: Adjust the Query to the needed one.
‣
Example ABL
3. Attribute EntityName: Adjust the name (last part) to the name of your new created entity.
2. Create DSO out of the entity.
1. Go to the screen Entities + fields and open Generate datasources.
2. Enter a name and module
3. Select in the drop down the field “Entity”
4. Select your newly created “Entity” from step 1
5. enter a temp table name. E.g. eCustomerOrder
3. Configure DSO and Create needed objects out of the DSO
1. Now you can test you new instance by opening the URL [YOUR CURRENT GITPOD URL]/web/Resource/[RESOURCENAME OF THE DSO].
1. Take the resourceName out of the attribute resourceName of the DSO.
2. To Create the desired objects for this entity, e.g. a grid, go to menu Grids and use the function Generate Grids.
1. Choose a Name, Title and Description (in field Name can also be added a new one).
2. Choose your created Entity.
3. Choose your fields (you can also type in an asterisk * to have all the fields).
4. Choose your module.

Back to Documentation

Back to Home Page