Editing a report in the SQL Editor

Reports created with the Query Editor can subsequently be edited in the SQL Editor to manually modify the underlying SQL statement.

Procedure

1. Navigate to Extras > Report Manager > Reports
2. Select the desired report via the checkbox
3. Click the arrow next to "Edit" in the action bar

1. Select "SQL Editor" from the context menu
2. The SQL statement is displayed and can be edited
3. Save

Important notes

A report that has been edited in the SQL Editor can no longer be opened in the visual Query Editor — even if it was originally created there. This switch is a one-way street.

Therefore, create a copy of the report before switching to the SQL Editor. This way the original remains editable in the Query Editor.

When is the SQL Editor useful?

• More complex queries that the Query Editor cannot handle (e.g. subqueries, JOINs across multiple tables)
• Custom sorting via ORDER BY
• Calculated fields or special formatting
• Duplicate checks (e.g. duplicate serial numbers)

The first column in the SQL must always contain the object ID:

SELECT obj_main.isys_obj__id AS '__id__', ...

Detailed documentation: Report Manager in the Knowledge Base