Report query

CLEM.Reporting.ReportQuery

This will perform an SQL query on the parent report saving the results to the database

While the standard reports (e.g. Resource ledger report) provide all the information needed to summarise your model results, they are often not the best format for quickly analysing model runs. This report component allows you to apply a custom SQL select query on any APSIM report (parent component in tree) with the results saved to the database for further analysis or graphing.

This report component requires an understanding of Structured Query Language (SQL) and will not perform any error checking on your SQL statement. We recommend that you test your statement in another application (e.g. DB Browser) using the SQLite table you are interested in working with.

The following parameters are used to define this activity and entered under the Properties tab in the user interface

The SQL select statement to use. This can be presented over multiple lines

This component will not check the validity of the SQL string and care should be taken not to use any destructive statements that will modify the database. The model will throw an exception during execution if this statement fails.

See also