Open the application in the Object Manager
panel.
Under the Detail
section, choose the Contained Objects
tab.
The Contained Objects
page appears.
Choose Expression
from the Type
field and choose Create Object
.
In the Object Creation
dialog box that appears, choose DB Lookup
in the Type
field.
Enter the following data:
Name
(Optional) Short Text
(Optional) Text
Choose Create and navigate to object
.
The newly created DB Lookup expression appears in the Object Manager
panel.
Note
If you choose Create
the DB Lookup expression appears under the Contained Objects
tab.
Select the mode.
You can choose data retrieval mode, aggregation mode or existence check mode.
Select Data Retrieval Mode
In this mode, the data is retrieved from the database table.
Choose All Entries
or Single Entry
.
Enter the name of the table in the text box and press Enter.
Assign a condition using the fields of the database table.
You can select an existing data object, create a new data object or create a result from the table.
Select an Existing Data Object
Choose (Graphical Access
).
In the context menu, choose Select...
.
In the Object Query
dialog box that appears, select the data object.
Create a New Data Object
Choose (Graphical Access
).
In the context menu, choose Create...
.
In the Object Creation
dialog box that appears, create the data object.
For more information, see Creating Data Objects
Create Result from Table
Choose (Graphical Access
).
In the context menu, choose Create Result From Table
.
In the dialog box that appears with the field of the database table, select the required fields.
Enter a name for the structure, table or element.
Select Aggregation Mode
In this mode, the result of the aggregation is returned from the database table.
Choose Aggregation
from the Selection Mode
field.
Enter the name of the table in the text box and press Enter.
Choose the aggregation type. You can choose maximum, minimum, average, count or sum.
Choose Distinct
or All
.
Assign a condition using the fields of the database table. You can select an existing data object or create a new data object.
Select an Existing Data Object
Choose (Graphical Access
).
In the context menu, choose Select...
.
In the Object Query
dialog box that appears, select the data object.
Create a New Data Object
Choose (Graphical Access
).
In the context menu, choose Create...
.
In theObject Creation
dialog box that appears, create the data object.
For more information, see Creating Data Objects
Select Existence Check Mode
In this mode, the result object is assigned true or false based on whether atleast one entry satisfies the WHERE condition that exists in the DDIC table.
Choose Existence Check
from the Selection Mode
field.
Enter the name of the table in the text box and press Enter.
Assign a condition using the fields of the database table.
You can select an existing data object, create a new data object or choose a Boolean.
Select an Existing Data Object
Choose (Graphical Access
).
In the context menu, choose Select...
.
In the Element Query
dialog box that appears, enter the name of the data object and choose Search
.
The data object appears under the Search
button.
Select the data object.
Create a New Data Object
Choose (Graphical Access
).
In the context menu, choose Create...
.
In the Object Creation
dialog box that appears, create the data object.
For more information, see Creating Data Objects
Select a Boolean
Choose (Graphical Access
).
In the context menu, choose Boolean
.
Choose the Activate
button.
Save the expression.