Creating a DB Lookup Expression

Show TOC

Creating a DB Lookup Expression

Procedure

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.

End of the note.
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.
  1. Choose All Entries or Single Entry.
  2. Enter the name of the table in the text box and press Enter.
  3. 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.
  1. Choose Aggregation from the Selection Mode field.
  2. Enter the name of the table in the text box and press Enter.
  3. Choose the aggregation type. You can choose maximum, minimum, average, count or sum.
  4. Choose Distinct or All.
  5. 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.
  1. Choose Existence Check from the Selection Mode field.
  2. Enter the name of the table in the text box and press Enter.
  3. 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.