Working with the SQL panel
EXAMPLE
Query the original value and original time stamp of the data point elements ExampleDP_Arg1 and ExampleDP_Arg2 (both of data point type ExampleDP_Float) using the SQL panel. Of course, you can also use other data points you have created yourself for this example.
Solution:
-
Open the SQL panel from the System management panel:
-
On the "Select" tab select "_original.._value" and "_original.._stime" from the "Configuration" combo box and click
or 
to add them to the list of
SELECT statements.Figure 1. Figure: Elements of the SELECT statement 
-
On the "From" tab use the data point selector to select the data points to query (here "ExampleDP_Arg1" and ExampleDP_Arg2") and click or to add them to the list of
FROM statements.
Figure 2. Figure: Elements of the FROM statement 
-
Now press "Create query" to build the query which is displayed in the bottom line of the SQL panel (see below). This displays the data tab.
Figure 3. Figure: Query statements 
-
On the "Data" tab click "Start query" to trigger the database query.
Figure 4. Figure: Database query 
The query and the data returned from the database are displayed on the Data tab. The first column lists the statements in the FROM statement ("ExampleDP_Arg1" and "ExampleDP_Arg2") and the remaining columns display the values returned by the SELECT statement (here "_original.._value" and "_original.._stime").
