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

com.ergotech.vib.historical.DatabaseRawLookup

===Introduction===

This server is used with a [[DatabaseConnectionManagerDocumentation|Database Connection Manager]] to read a single value from a database table using a SQL Statement.  The DatabaseRawLookup 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 must return a single result (not a list or array). The SQL should be a SELECT or COUNT, or other similar statement. There are two outputs: Result and Status Message. The result of the SQL lookup will be sent to the Result output, and the Status Message can be used to monitor for errors.

===Using in a Script===


===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