Using Dynamic Where Clauses
Dynamic where clauses are used in a subscription generator, when the criteria values for generating subscriptions are in one table, but the corresponding employee keys are in another.
Note
Use the most basic mapping possible, since otherwise system performance is affected. For complex displays, use a function call.
You have called up the subscription generator wizard in the administration console, and have selected an intelligent publication. You are in the wizard step Set Criteria Rules
.
Proceed as follows:
Select the criteria field for which you want to define a dynamic where clause, and choose
(Dynamic Where Clause
).
This function is not supported for the Between operator.
Under Table Name
on tab page Mapping
, specify the name of the table that contains the attribute for the criteria field.
The field is preassigned with the specifications for the criteria field.
Under Field Value to Be Read
, specify the name of the field from which the values for generating the subscription should be taken.
The field is preassigned with the specifications for the criteria field.
Select the first row, and choose
(Insert Row
). Create enough rows so that you are able to specify all the tables necessary to determine the employee key.
Specify the table name, and the field in which the employee key can be found.
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
(Field Relation
).
The Relation Fields Between Tables
screen is displayed.
Enter the following:
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.
An AND link takes priority over an OR link. End of the caution. The sequence in which the rows are entered is important. |
To submit the entries, determine the relation between all specified tables and choose
(Okay
).
You can use
(Static Where Clause
) to define further static conditions for generating subscriptions, for each entry in the table Mapping
. See also: Using Static Where Clauses.
The activities that have been executed for each row of the table are displayed in the Status
field.
To submit the entries, choose
(Okay
).