Using Static Where Clauses

Use

Static where clauses can be used in a subscription generator, where the criteria values for generating the subscription and the corresponding employee keys are located in one table.

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:

Select the criteria field for which you want to define a static where clause, and choose .

The relevant tab pages for entering static where clauses are opened.

This option is not possible for the Between operator.
In the Table tab page, under Table, specify the name of the table that contains the values for generating the subscription.

The field is preassigned with the specifications for the criteria field.
Under Field To Be Read, specify the name of the field from which the values for generating the subscription are to be read.

The field is preassigned with the specifications for the criteria field.
Under Field Employee Key to Be Read, specify the field that contains the table of employee keys.

If this field remains blank, all employee keys are linked to all values read from Field To Be Read.

Switch to the Value tab page, and enter further conditions under which values can be found.

Entries for Static Where Clauses
Field Name	Entry
Field Name	From the table, select a field that is relevant for the creation of the subscription.
Operator	-
Static Value	Define the static value that is valid for the clause.
AND/OR	Enter AND or OR to link several rules. Caution An AND link takes priority over an OR link. Example COUNTRY=DE AND REGION=08 OR REGION=09 The system searches for all records where both COUNTRY=DE and REGION=08. Those records where REGION=09 are also included in the search. The sequence in which the rules are entered is important.

A maximum of nine rules can be defined.

To submit your entries, choose .

Example

For the publication Activities (by Employee), the criteria field SFAMITABT exists for the segment ACT_RESPONSIBLE.

By specifying a static where clause, subscriptions should be generated that assign activities to each employee. To do this, the following entries are required:

Entries in Tab Page Table
Field Name	Entry
Table	SMOKVBEZ11
Field To Be Read	SFAMITABT
Field Employee Key to Be Read	SFAMITABT

Entries in Tab Page Value
Field Name	Entry
Field Name	DELETED
Operator	=
Static Value	0
AND/OR	empty

These entries are read as follows:

From table SMOKVBEZ11, field SFAMITABT, take all employee keys for which DELETED = 0, and use the values in the subscription to be generated.