Creating and Changing Conditions 
Creating and Changing Conditions
Definition
Instruction for a query view.
Use
'You can change existing (local) conditions and define new (local) ones with this command.
Conditions that were defined in the Query Designer cannot be changed.
Structure
|
CMD |
SET_CONDITION |
|
Parameter |
Description |
|
CONDITION_ID (optional) |
ID of the condition to be changed If there is no condition with this ID, a new condition is created. A new exception is also created if this parameter is not filled. |
|
ACTIVE ‘X’ = Yes, ‘ ’ = No |
Condition active |
|
DESCRIPTION |
Description This text is displayed in the list of conditions. |
|
IOBJNM_I |
List of characteristics List of the characteristics for which the condition should be applied in combination. If no characteristic is specified, the condition is applied to all characteristics. |
|
STRUCTURE_MEMBER_1_I |
Component of the first structure A condition always refers to exactly one value cell. To do this, you have to specify the components of the structure (25-character string) for all the occurring structures (maximum 2). |
|
STRUCTURE_MEMBER_2_I |
Component of the second structure (if it exists) |
|
OPERATOR_I |
An operator 'EQ' = Equal to 'NE' = Not equal to 'BT' = Interval 'LE' : Less than or equal to 'LT' = Less than 'GE' : Greater than or equal to 'GT' = Greater than 'TC' = Top n 'TP' = Top percent 'TS' = Top sum 'BC' = Bottom n 'BP' = Bottom percent 'BS' = Bottom sum |
|
VALUE_LOW_I |
Numerical value for operator |
|
VALUE_HIGH_I |
Numerical value for operator Only the interval operator needs this value. |