Page History

...

The image below shows all of the properties that are available to be customized.  

Creating Statements

After one of the selected table is loaded tables is selected into the Sub-query Structure, you can see that there will be a statement is initialized at the bottom of the page. 

To filter individual columns from the table, it is required only to check the element CheckBox.

If none is selected, then your querie will return all table elements.

...

There are some columns in which it is possible to add conditions to filter values from the table.

The column options are:

• Visible: Remove the column from the query result;
• Expression: Original column name;
• Column Name: Give a table, or a column in a table, a temporary Aliases are often used to make column names more readable. An alias only exists for the duration of the query.
• Sort Type: Sort the result-set in ascending or descending order.
• Sort Order: Sort columns order in result
• Aggregate: the values of multiple rows are grouped together as input on certain criteria to form a single value of more significant meaning. E.g.: Avg, Count, Sum.
• Grouping: Group column elements. Enable creating filtering conditions for groups or
• Criteria: Selection condition criteria. E.g.: =, >, <, ! =.
• Or: Same as the Criteria

...

To better illustrate the Query Builder feature, let’s create an example . Assuming which assumes the following requirements for our query result:

• Only the UTCTimestamp Ticks and HistoricalTag columns are
• All column names need to have be easy to understand
• Elements will be sorted in Ascendingascending order
• We only want values from HistoricalTag HistoricaTag values between 10 and 35

Filling Fill in the columns with the required information to perform the query as these requirements as seen in the image below. 

The If everything was filled in correctly, the final SQL Statement generated by the Query Builder wasshould be:

Select Table1 . Historical Tag As TagValue , Table1 . UTCTimestamp Ticks As Date
From Table1
Where Table1 . Historical Tag = Table1 . Historical Tag > 10 And Table1 . Historical Tag <= 35
Order By TagValue , Date

...