Up: Component summary
Up: Component summary
Function
QueryReportExecutes an SQL query and prints it with the result table.
| Version | 1.2 |
|---|---|
| Bundle | tools |
| Categories | Latex |
| Authors | Marko Laakso (Marko.Laakso@Helsinki.FI) |
| Issue tracker | View/Report issues |
| Source files | component.xml function.scala |
| Usage | Example with default values |
Inputs| Name | Type | Mandatory | Description |
|---|---|---|---|
| query | SQL | Mandatory | Query to be executed for the given data |
| table1 | CSV | Mandatory | 1. data table that is referred as 'table1' in the query |
| table2 | CSV | Optional | 2. data table that is referred as 'table2' in the query |
| table3 | CSV | Optional | 3. data table that is referred as 'table3' in the query |
| table4 | CSV | Optional | 4. data table that is referred as 'table4' in the query |
| table5 | CSV | Optional | 5. data table that is referred as 'table5' in the query |
| table6 | CSV | Optional | 6. data table that is referred as 'table6' in the query |
| table7 | CSV | Optional | 7. data table that is referred as 'table7' in the query |
| table8 | CSV | Optional | 8. data table that is referred as 'table8' in the query |
| refs | CSV | Optional | Reference rules for the hyperlinks. The exact specification of the file can be found from the description of the CSV2Latex component. |
Outputs| Name | Type | Description |
|---|---|---|
| report | Latex | This document containst a table of results and the original query if requested. |
| data | CSV | Result relation for further processing |
Parameters| Name | Type | Default | Description |
|---|---|---|---|
| colFormat | string | "center" | LaTeX tabular formatting for the result columns |
| instanceName | string | (no default) | Instance name to which the call to this function is assigned. |
| listCols | string | "" | Comma separated list of column names. Columns of this list may contain several values separated with commas and the delimiters will be replaced with spaces. |
| section | string | "Query results" | Subsection title for the output document |
| showCols | string | "" | Comma separated list of column selections for the output. The empty default will use all columns. |
| showQuery | boolean | true | This flag tells if the SQL shall be shown on the report |
| tableCaption | string | "Results for the query" | Description for the result table |
Test cases| Test case | Parameters▼ | IN query |
IN table1 |
IN table2 |
IN table3 |
IN table4 |
IN table5 |
IN table6 |
IN table7 |
IN table8 |
IN refs |
OUT report |
OUT data |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| case1 | properties | query | table1 | (missing) | (missing) | (missing) | (missing) | (missing) | (missing) | (missing) | refs | report | data |
|
instanceName=test |
|||||||||||||