This extract allows retrieval of data from a table or view of a relational database without writing a SQL query statement. It allows selecting columns with aliases, filtering with WHERE and HAVING clauses, sorting, and aggregation.
|Connection:||Connection to a relational database.|
|Schema:||The name of the schema in the relational database (if database engine supports schemas).|
|Table:||The name of the table in the relational database.|
|Output Columns:||Columns that should be returned by relational table extract.|
|Logical Filter Expression:||
A Boolean condition can be applied for if several filter conditions have been defined. Valid symbols are: [0-9] ( ) AND OR NOT
If no logical filter expression is defined an AND filter is applied, i.e. 1 AND 2 AND … AND n.
|Sorting:||Ascending or descending order of the entered column.|
|Distinct:||When checked, only distinct values from the source are returned.|
Use aggregate functions from a relational source. Select the column and type of aggregation. If aggregate functions are used, the GROUP-BY statement is automatically generated from output columns table.
Possible aggregations are:
* duplicated result rows are not calculated
|Having-Filter:||Same as Where-Filter, but applied to result of aggregated columns.|
|Logical Filter Expression:||Same as logical filter expression, but applied to Having-filters.|
An optional part of a SQL query with additional options that are appended to the generated SQL statement.
LIMIT 10 OFFSET 10
Memory, disk or none (default). See article Caching in Extracts.
Note: if you require other SQL capabilities not covered by this extract, you either have to use a Relational extract, which allows a free SQL query statement, or you have to use separate relational table extracts with subsequent changes.
- Nested SQL statements