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.