The subtable_insstring column can be used to subtable data to a new JobRouter instance. The assignment is done by an SQL statement. The statement is executed in the same database and the result records are copied into the respective JobRouter subtable. To make the item data available it is recommended to create a new table with the necessary columns.
To perform an assignment, first enter the name of the subtable, then a = and the SQL statement used to determine the records. If multiple subtables are to be filled, the individual entries have to be separated by a semicolon.
Example:
The following SQL statement accesses the ITEMIMPORT table and selects all entries with the value 5 in the ID column. Three fields, field1, field2 and field3 are read. To assign them to the JobRouter fields of the subtable called Items, the fields have to receive aliases (material, amount, price). Those aliases have to correspond to the field names of the subtable.
Items=SELECT field1 AS material, field2 AS amount, field3 AS price
FROM ITEMIMPORT
WHERE ID = 5
The following table shows example entries of the table ITEMIMPORT.
id |
posid |
field1 |
field2 |
field3 |
|---|---|---|---|---|
5 |
1 |
material1 |
12 |
133.30 |
5 |
2 |
material2 |
4 |
120.00 |
5 |
3 |
material3 |
3 |
22.00 |
6 |
1 |
material33 |
32 |
13.40 |
6 |
2 |
material21 |
3 |
21.00 |
6 |
3 |
material4 |
4 |
32.00 |
The abovementioned SQL statement would import the columns marked gray to the subtable Items.
