Edit

Applies to: Kyvos Reporting

The Edit tab allows you to view and write complex SQL statements that cannot be created using the Design tab. When you switch from the Design tab to the Edit tab, the system constructs and displays the designed query as a complete SQL statement.

Writing SQL Queries

Use the Edit tab to write or modify custom SQL queries manually.
This is especially useful for complex queries, subqueries, unions, or advanced filtering logic.
You can also write dynamic SQL queries on this tab. Refer to the Dynamic SQL Query section for details.

Note

The SQL defined in the Edit tab is considered the final SQL used at runtime.

Overwrite Warning

If you modify a complex query in the Edit tab and then switch to the Design tab to make visual changes, Intellicus prompts you to confirm whether the existing SQL should be retained.

Yes: The SQL will be regenerated based on the changes made in the Design tab. This will overwrite the manually written SQL in the Edit tab.
No: The SQL defined in the Edit tab remains unchanged and is retained as the final SQL.

Tip

To preserve complex SQL logic, avoid switching back to the Design tab after writing your query in the Edit tab unless necessary.