ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Changing 'Report Settings' for a report based on 'Sql Query with Paramaters' will remove line breaks from query.

book

Article ID: 172332

calendar_today

Updated On:

Products

Workflow Solution ServiceDesk

Issue/Introduction

Changing setting - 'Report Settings' link/button at the top left of the report - for a report based on 'Sql Query with Paramaters' will remove line breaks from query, potentially breaking the query.

Varies, generally displays an error message about incorrect statement or column name.

Cause

Line breaks are removed from the query.

Environment

Workflow 7.5
Workflow 7.6
Workflow 8.0
Workflow 8.1
Workflow 8.5

ServiceDesk 7.5
ServiceDesk 7.6
ServiceDesk 8.0
ServiceDesk 8.1
ServiceDesk 8.5

Resolution

This issue is fixed in Workflow 8.5 RU1 and ServiceDesk 8.5 RU1.

Workaround:

To work around the issue, please make sure every line in the query has a space in the end. This way, when line breaks get removed there is still a space there.

Note that once you have run into this issue, IIS may need to be restarted to get the report out of non-working state even after report has the spaces added. This is because parameters state for a report is cached.