Using Dynamic Where Clauses 

Use

Dynamic where clauses are used in a subscription generator where the criteria values for generating the subscription are located in one table, but the corresponding employee keys are in another.

Use the most basic mapping possible as system performance will otherwise be affected. For complex displays use a call function.

Prerequisites

You have called up the subscription generator wizard in the administration console and have selected an intelligent publication. You are in Defining criteria rules in the wizard.

Procedure

Proceed as follows:

...

       1.      Select the criteria field for which you want to define a dynamic where clause and choose  (Dynamic where clause).

With the BETWEEN operator, this function is not supported.

       2.      Under Table name, tab page Mapping, specify the name of the table that contains the attribute for the criteria field.

The field is preassigned with the criteria field specifications.

       3.      Under Field value to be read, specify the name of the field from which the values for generating the subscription are to be fetched.

The field is preassigned with the criteria field specifications.

       4.      Select the first row and choose  (Insert row). Create enough rows that you are able to specify all the tables necessary to determine the employee key.

       5.      Specify the table name and the field in which the employee key can be found.

       6.      To determine the relation between the tables in the first and next rows of the matrix, select the first row of the matrix and choose (Relation field).

The Relation field between tables screen is displayed.

       7.      Enter :-

Entries for relation fields

Field	Entry
Field name	Specify the relation field for the first table.
Operator
Field name	Specify the relation field for the second table.
AND/OR	Enter AND or OR to link several entries together. An AND link takes priority over an OR link. The sequence in which the rows are entered is very important.

       8.      To submit the entries, determine the relation between all specified tables and choose (Copy).

       9.      Further static conditions for generating subscriptions can be determined for each entry in  (Static where clauses) in the table Mapping. See also: Using Static Where Clauses.

   10.      The activities that have been executed for each row of the table are displayed in the Status field.

   11.      To submit the entries, choose  (Copy).