You can create objects with data from multiple tables. In the standard objects the objects are always created for one table only.
‣
‣
‣
You can create objects with data from multiple tables. In the standard objects the objects are always created for one table only.
SourceTables: Insert all the required tables comma-separated with the naming databasename.tablename.SourceQuery: Adjust the Query to the needed one.FOR EACH table1,
EACH table2 OUTER-JOIN WHERE table1.keyA = table2.keyB,
EACH table3 OUTER-JOIN WHERE table2.keyC = table3.keyD
INDEXED-REPOSITIONEntityName: Adjust the name (last part) to the name of your new created entity.InstanceName = eNAMEEntityName = eNAME EntityName = eName: Use the same name as in InstanceName.[YOUR CURRENT GITPOD URL]/web/Resource/[RESOURCENAME OF THE DSO].resourceName of the DSO.Generate Grids.* to have all the fields).