Designing SQL Statement
Applies to: Kyvos Reporting
The Design tab displays a complete SQL statement, organized into its individual clauses. These clauses are populated based on the objects selected in the diagram pane.
You can edit any clause directly in its text area. Adding a column in the clause reflects in the diagram pane. However, removing a column from the clause may not update the diagram automatically.
Tip
Press Ctrl + Spacebar to access a context-sensitive list of available values in all clause sections.
SQL Clauses in the Design Tab
Select Clause
Displays the columns selected from the diagram pane. You can:
Add or remove columns directly in the clause.
Edit column expressions manually.
Changes in this clause are reflected in the diagram pane, but deletions might not sync visually.
Where Clause
Each condition appears in a separate row. Use this clause to define filter criteria.
Option | Description |
|---|---|
Open | Adds an opening parenthesis to group conditions. |
Operand 1 | A dropdown that lists all available column names and defined parameters. |
Operator | A dropdown of comparison operators (e.g., =, >, <, LIKE). |
Operand 2 | A dropdown of column names and parameters for comparison with Operand 1. |
Close | Adds a closing parenthesis to complete a grouped condition. |
Relation | Logical connector (AND / OR) to relate the current condition to the next. |
Group By Clause
Use the Group By clause to define grouping criteria for your SQL statement. Grouped columns typically match the structure of grouped sections in the report layout.
Having Clause
Define conditions to filter grouped records. This clause works similarly to the Where clause but is applied after grouping.
Order By Clause
Specify sorting criteria (ascending or descending) for the result set.
Important
If your report includes grouping, ensure that the Order By clause lists the columns in the same sequence as the group sections defined in the layout designer.