KB-60787: Querying raw data in an E3Storage.

Question:

Can I query the raw data recorded via E3Storage? I just want to visualize the actual data, with no interpolation function estimating values.

Solution:

Currently, E3Storage’s query has no function to return raw data. Therefore, you will have to create your own query and manipulate its SQL code directly.

An example of query would be:

      SELECT l1.E3TimeStamp, l1.FieldValue
      FROM TabelaStorage1 l1, (




         SELECT FieldID
        
FROM TabelaStorage1_Fields
      
  WHERE FieldName =
'<%varFieldName%>' 

     
   ) l2 

      WHERE l1.FieldID =
l2.FieldID

This sample query has a variable called varFieldName, which must be filled with the name of the desired field.