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 |
logicaloperator |
Logical operators: AND, OR, NOT |
condition |
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 |
|
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 |
logicaloperator |
Logical operators: AND, OR, NOT |
doccondition |
logicaloperator |
Comparison operators: eq, neq, in, notin, exists, notexists, is_null, is_not_null, |
|
tablename |
Name of the table containing the table fields already extracted |
|
fieldname |
Column name |