Databases Reference
In-Depth Information
Eventually, each of the leave predicates in the overall predicate tree must contain one
or more clause elements, the structure of which is shown in the following screenshot:
The
clause
element is made up of three core parts: the
column
element where we
define the task attribute that we wish to query, the
operator
(for example, equal,
not equal, and so on), and the value we want to compare it against.
The
column
consists of two parts:
•
The attribute
tableName
: This should contain the name of the database table
in the SOAINFRA schema that we wish to query. This will typically be the
table WFTASK.
The element
columnName
: This should contain the name of the column
on the specified
tablename
that we wish to query (which, in our case, is
TaskDefinitionName
).
•
The
operator
specifies the type of comparison that we wish to carry out. The valid
operators are as follows:
•
Standard operators
:
EQ
(Equal),
NEQ
(Not Equal),
GT
(Greater Than),
GTE
(Greater Than or Equal),
LT
(Less Than), and
LTE
(Less Than or Equal)
String operators
:
LIKE
,
NOT_LIKE
,
CONTAINS
,
NOT_CONTAINS
,
BEGINS
,
NOT_
BEGINS
,
ENDS
, and
NOT_ENDS
Date operators
:
BEFORE
,
AFTER
,
ON
,
NEXT_N_DAYS
,
and
LAST_N_DAYS
Value list operators
:
IN
and
NOT_IN
Null operators
:
IS_NULL
and
IS_NOT_NULL
•
•
•
•
