Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...


...


Integer Data

...

...

Code Block
languagesql
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
languagesql
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
languagesql
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";