Edit SQL for File and Document Name

Create or edit the SQL for file and document names, taking the following notes into account:

The SQL query must be a SELECT statement that returns exactly one VARCHAR value. The result column can be named freely, but this is not required. The result is then used as both the file name and the document title.

The name must not contain any characters that are not permitted in filenames (".", "\" etc.).

The parameters available in SQL vary depending on the target object. These are displayed on the right side of the window after opening the SQL editor. Parameters in SQL are identified by a leading "@" symbol.

Example of a report with the target object "Service report":

SELECT 'Servicebericht Nr ' + CAST(BELEGNR AS VARCHAR(20)) FROM LBKOPF WHERE ISGUID = @targetIsGuid