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 |
logicaloperator |
Logical operators: AND, OR, NOT |
condition |
logicaloperator |
Comparison operators: eq, neq, in, notin, num_gt, num_geq, num_lt, num_leq, like |
|
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 operator: AND, OR, NOT |
Doccondition |
logicaloperator |
Comparison operator: eq, neq, in, notin, exists, notexists |
|
tablename |
Name of the table containing the table fields already extracted |
|
fieldname |
Column name |