How to get custom script retained data values

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