Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
databaserawlookupdocumentation [2022/01/02 21:46] wikiadmin [How This is Used] |
databaserawlookupdocumentation [2022/01/02 21:57] (current) wikiadmin [Introduction] |
||
|---|---|---|---|
| Line 5: | Line 5: | ||
| ===Introduction=== | ===Introduction=== | ||
| - | This server is used with a [[DatabaseConnectionManagerDocumentation|Database Connection Manager]] to read a single value from a database table using a SQL Statement. | + | 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=== | ===Using in MIStudio=== | ||
| - | This Bean has a single input (Trigger) which executes the SQL Statement. The SQL Statement must return | + | 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=== | ===Using in a Script=== | ||