Table of Contents

Database Raw Lookup

com.ergotech.vib.historical.DatabaseRawLookup

Introduction

This server is used with a 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 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