Use the following SQL queries to return values for the specified data types.
...
...
Integer Data
...
Code Block | ||
---|---|---|
| ||
SELECT e.name,p.name,d.value,d.sampletime FROM erdc_int_data d, erdc_instance e, erdc_parameter p |
...
where e.erdc_instance_id = d.erdc_instance_id |
...
and p.erdc_parameter_id = d.erdc_parameter_id |
...
and e.name like "INSTANCE_NAME"; |
...
|
...
Decimal Data
...
Code Block | ||
---|---|---|
| ||
SELECT e.name,p.name,d.value,d.sampletime FROM erdc_decimal_data d, erdc_instance e, erdc_parameter p |
...
where e.erdc_instance_id = d.erdc_instance_id |
...
and p.erdc_parameter_id = d.erdc_parameter_id |
...
and e.name like "INSTANCE_NAME"; |
...
...
String Data
...
Code Block | ||
---|---|---|
| ||
SELECT e.name,p.name,d.value,d.sampletime FROM erdc_string_data d, erdc_instance e, erdc_parameter p |
...
where e.erdc_instance_id = d.erdc_instance_id |
...
and p.erdc_parameter_id = d.erdc_parameter_id |
...
and e.name like "INSTANCE_NAME"; |