Table of Contents

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