2022 April Release

Enum COOSYSTEM@1.1:ConditionOperator Permanent link for this heading

Defines the operators which can be used in conditions. The operators CONDOP_BETWEEN and CONDOP_NOTBETWEEN include the bounds of the specified interval.

Additional Information

Values Permanent link for this heading

Name

Value

Description

CONDOP_LIKE

1

LIKE

The property value must be like the specified value. You can use the wildcards *, ?, % and _ with this operator.

CONDOP_NOTLIKE

2

NOT LIKE

The property value must not be like the specified value.

CONDOP_IN

3

IN

The property value must be in the specified values.

CONDOP_NOTIN

4

NOT IN

The property value must not be in the specified values.

CONDOP_ISNULL

5

IS NULL

The property value must be NULL.

CONDOP_ISNOTNULL

6

IS NOT NULL

The property value must not be NULL.

CONDOP_LS

7

<

The property value must be smaller than the specified value.

CONDOP_LE

8

<=

The property value must be smaller than or equal the specified value.

CONDOP_GR

9

>

The property value must be greater than the specified value.

CONDOP_GE

10

>=

The property value must be greater than or equal the specified value.

CONDOP_EQ

11

=

The property value must equal the specified value.

CONDOP_NE

12

<>

The property value must not equal the specified value.

CONDOP_BETWEEN

13

BETWEEN

The property value must be in the specified interval. The bounds are included.

CONDOP_NOTBETWEEN

14

NOT BETWEEN

The property value must not be in the specified interval. The bounds are included.

CONDOP_SOUNDSLIKE

15

SOUNDS LIKE

CONDOP_SOUNDSNOTLIKE

16

SOUNDS NOT LIKE

CONDOP_CONTAINS

17

CONTAINS

CONDOP_NOTCONTAINS

18

NOT CONTAINS

CONDOP_INCLUDES

19

INCLUDES

CONDOP_NOTINCLUDES

20

NOT INCLUDES