Page History

...

After the selected table is loaded into the Sub-query Structure, there a statement will be a statement initialized at the bottom of the page. 

To You can 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.

Image Removed

by selecting specific checkboxes. When you do, the system will filter the table results based on your selection. If you do not select any checkboxes, the table will have not have any filters. 

Image Added

The columns allow you to add conditions which 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 entire column from the query result;results
• Expression: Original The original column name;
• Column Name: Give a table, or a column in a table, a temporary name. 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 results in ascending or descending order.
• Sort Order: Sort the order of the columns order in resultthe results
• Aggregate: the 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. Criteria for the selection condition E.g.: =, >, <, ! =.
• Or: Same as the Criteria

...