Using Static Where Clauses
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.
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 static where clause, and choose
(Static Where Clause
).
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.
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.
An AND link takes priority over an OR link. End of the caution.
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. End of the example. |
A maximum of nine rules can be defined.
To submit your entries, choose
(Okay
).
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:
Field Name | Entry |
|---|---|
Table | SMOKVBEZ11 |
Field To Be Read | SFAMITABT |
Field Employee Key to Be Read | SFAMITABT |
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.
Note
If the field Field Employee Key to Be Read
were left blank, all employee keys found would be assigned to all employees. The employee keys from table SMOMITABT would then be read.
Since the field is filled, each employee receives only those records with his or her employee key.