Show TOC

Procedure documentationUsing 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 Note

Use the most basic mapping possible, since otherwise system performance is affected. For complex displays, use a function call.

End of the note.

Prerequisites

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.

Procedure

Proceed as follows:

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

    This function is not supported for the Between operator.

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

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

  4. Select the first row, and choose Insert Row (Insert Row). Create enough rows so 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 Field Relation (Field Relation).

    The Relation Fields Between Tables screen is displayed.

  7. Enter the following:

    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.

    Caution Caution

    An AND link takes priority over an OR link.

    End of the caution.

    The sequence in which the rows are entered is important.

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

  9. You can use Static Where Clause (Static Where Clause) to define further static conditions for generating subscriptions, for each entry 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 Okay (Okay).