Creating a DB Lookup Expression

The Contained Objects page appears.

• Name

• (Optional) Short Text

• (Optional) Text

The newly created DB Lookup expression appears in the Object Manager panel.

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

       1. Choose .

       2. In the context menu, choose Select....

       3. In the Object Query dialog box that appears, select the data object.

     • Create a New Data Object

       1. Choose .

       2. In the context menu, choose Create....

       3. In the Object Creation dialog box that appears, create the data object.

          For more information, see Creating Data Objects

     • Create Result from Table

       1. Choose .

       2. In the context menu, choose Create Result From Table.

       3. In the dialog box that appears with the field of the database table, select the required fields.

       4. 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

       1. Choose .

       2. In the context menu, choose Select....

       3. In the Object Query dialog box that appears, select the data object.

     • Create a New Data Object

       1. Choose .

       2. In the context menu, choose Create....

       3. In the Object 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

       1. Choose .

       2. In the context menu, choose Select....

       3. 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.

       4. Select the data object.

     • Create a New Data Object

       1. Choose .

       2. In the context menu, choose Create....

       3. In the Object Creation dialog box that appears, create the data object.

          For more information, see Creating Data Objects

     • Select a Boolean

       1. Choose .

       2. In the context menu, choose Boolean.