SubTables
A comma-separated list of sections in the configuration file that configure extraction of data from sub tables (which contain data linked to the main table). For example:
[MyTask] ConnectionString=... PrimaryKeys=item_id Template=inventory.tmpl SQL=SELECT * FROM inventory SubTables=SubTableSection [SubTableSection] Template=flow.tmpl SQL=SELECT * FROM flow WHERE item_id = @item_id
In the preceding example, the table flow
is linked to the main table (inventory
). The table flow
has a separate SQL statement that is run for every row returned from the main table. The table also has its own template file, which is merged with the main template. For more information about constructing templates, see Construct Template Files.
The tables are linked by the item_id
column. In the SQL statement for the flow
table, the connector replaces @item_id
with the item_id
returned from the inventory
table. (The connector replaces any items in the SQL statement marked with @
with the value from the main table).
If the main query returned rows with the item_id
column ranging from 1-10, the connector would run another query for each row. The first would be:
SELECT * FROM flow WHERE item_id = 1
and the second would be:
SELECT * FROM flow WHERE item_id = 2
and so on.
Type: | String |
Default: | |
Required: | No |
Configuration Section: | TaskName or FetchTasks |
Example: | Subtables=Table1,Table2
|
See Also: |