Extraction using conditions

Extracting data from the tables can be limited by the use of conditions. For example, you can use conditions to ensure that when extracting data from a table, only rows corresponding to a particular date field will be extracted. The conditions are specified directly in the configuration of the table specification in the booleancondition or condition XML element and only apply to the associated table.

A condition contains the name of the data field, the comparison operator, and a concrete value. Conditions can be linked with any degree of complexity (booleancondition XML element).

XML element

XML attribute

Description

booleancondition
(optional)

logicaloperator

Logical operators: AND, OR, NOT
Default value: AND

condition
(optional)

logicaloperator

Comparison operators: eq, neq, in, notin, num_gt, num_geq, num_lt, num_leq, like
Operators for restricting the data range to be extracted: creationtimestamp, valueconstraint
Default value: eq

 

fieldname

Table field name

The docbooleancondition and doccondition XML elements enable conditional extraction from a data table depending on table fields already extracted. They are configured in a similar way to booleancondition and condition. The table name and the name of the column containing the data fields already extracted are specified in the tablename and fieldname XML attributes.

XML element

XML attribute

Description

docbooleancondition
(optional)

logicaloperator

Logical operator: AND, OR, NOT
Default value: AND

Doccondition
(optional)

logicaloperator

Comparison operator: eq, neq, in, notin, exists, notexists
Default value: eq

 

tablename

Name of the table containing the table fields already extracted

 

fieldname

Column name