ErgoTechWiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.

=====Database Raw Table Lookup=====

com.ergotech.vib.historical.DatabaseRawTableLookup

===Introduction===

This server is used with a [[DatabaseConnectionManagerDocumentation|Database Connection Manager]] to generate a [[twodvalueobjects|Two Dimensional Value Object]] from a database table using a SQL Statement. The DatabaseRawTableLookup Bean is included in the Reporting module of MIStudio and TransSECS (see [[vibreportinganddatabaseserverbeansdocumentation|Reporting and Historical Servers]]).

===Using in MIStudio===

This Bean has a single input (Trigger) which executes the SQL Statement. The SQL Statement should be a SELECT which returns one or more rows and columns from the table. There are two outputs: Result and Status Message. The TwoDimensionalValueObject of the SQL lookup will be sent to the Result output, and the Status Message can be used to monitor for errors.

===Using in Scripts===
===Configuration===

**Connection Name**: Select the Database Connection Manager to use for this Bean

**SQL Statement**: The SQL Statement to execute when this Bean is triggered