This example demonstrates how Geo SCADA Expert might be configured to query data in an Oracle database, using the Row & Column Lookup Method.
An Oracle database includes the following database table:
Table Name: SCADADATA
|
ValueId |
Value |
PrevValue |
State |
|---|---|---|---|
|
1 |
10 |
15 |
Low |
|
5 |
21 |
20 |
Normal |
|
2 |
17 |
19 |
Low |
|
10 |
99 |
90 |
High |
Within Geo SCADA Expert, an ODBC Query is configured to:
- Retrieve the ValueId and Value columns of data from the SCADADATA table
- Sort the retrieved data by ascending ValueId column order.
To do this, the ODBC Query is configured to use this SQL query request:
This request returns the following results table to the Geo SCADA Expert ODBC driver:
|
ValueId |
Value |
|---|---|
|
1 |
10 |
|
2 |
17 |
|
5 |
21 |
|
10 |
99 |
Within Geo SCADA Expert, an ODBC Analog point is configured to return the value from the row ValueId 5. To do this, the point is configured to use a Row & Column Lookup Method with these settings:
This results in the ODBC Analog point having a value of 21.