Up: Component summary Function

QueryReport

Executes 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


Generated 2018-12-11 07:42:07 by Anduril 2.0.0