Database Raw Table Lookup
com.ergotech.vib.historical.DatabaseRawTableLookup
Introduction
This server is used with a Database Connection Manager to generate a 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 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