Page tree
Skip to end of metadata
Go to start of metadata

Use the following SQL queries to return values for the specified data types.

Integer Data

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

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

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";