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 Defining criteria rules in the wizard.

Procedure

Proceed as follows:

...

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

With the BETWEEN operator, this function is not possible.

       2.      Under Table, tab page Table, specify the name of the table that contains the values for generating the subscription.

The field is preassigned with the criteria field specifications.

       3.      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 criteria field specifications.

       4.      Under Field to be read: Employee key, specify the field that contains the table of employee keys.

If this field remains blank, all employee keys are linked to values read from the Field to be read.

       5.      Switch to the Value tab page and enter further conditions to specify where values are to be found.

Entries for static where clauses

Field name	Entry
Field name	Select a field from the table that is relevant for the attachment of the subscription.
Operator
Static value	Determine the static value that is to apply for the clause.
AND/OR	Enter AND or OR to link several rules together. An AND link takes priority over an OR link. Example COUNTRY=DE AND REGION=08 OR REGION=09 All records are found where both COUNTRY=DE and REGION=08. Those where the REGION=09 are also found. The sequence in which the rules are entered is very important.

A maximum of nine rules can be defined.

       6.      To submit your specifications, choose  (Copy).

Example

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

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

Entries in Tab Page Table

Field name	Entry
Table	SMOKVBEZ11
Field to be read	SFAMITABT
Field to be read: Employee key	SFAMITABT

 

Entries in Tab Page Value

Field name	Entry
Field name	DELETED
Operator	=
Static value	0
AND/OR	Blank

 

These entries are read as follows:

Get all employee keys from table SMOKVBEZ11 in field SFAMITABT for which DELETED = 0 and use the values found in the subscription to be generated.

If the field Field to be read: Employee key is left blank, all employee keys found will be assigned to all employees. In this case employee keys from table SMOMITABT are read.

As an entry has been made for the field, each employee obtains only those records assigned by his/her employee key.