Extraction using conditions

Extracting data from the tables can be limited by the use of conditions. For example, you can use conditions to control that, when extracting table fields, only document flows of one document type in a particular period are extracted. 

The conditions are specified directly in the table configuration in the booleancondition or condition XML element and only apply to the associated table.

A condition contains the name of the table 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, is_null, is_not_null, timestamp_eq, timestamp_geq, timestamp_gt, timestamp_leq, timestamp_lt, time_eq, time_geq, time_gt, time_leq, time_lt, date_eq, date_geq, date_gt, date_leq, date_lt, num_eq, num_neq, num_in, num_notin
Operators for restricting the data range to be extracted: char_creationtimestamp, date_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 operators: AND, OR, NOT
Default value: AND

doccondition
(optional)

logicaloperator

Comparison operators: eq, neq, in, notin, exists, notexists, is_null, is_not_null,
Default value: eq

 

tablename

Name of the table containing the table fields already extracted

 

fieldname

Column name