Raw SQL step with Parameter fails
Comments
-
I am running a query that executes successfully in the query editor, but when we use the same is run in the Raw SQL step, it throws an error. (See below). What should we do have the query execute successfully in the Raw SQL step?
[img]att2[/img]
[img]att1[/img]
[i]edited by Jibbin Mathew on 11/13/2020[/i] -
In the Raw SQL step, we will need to pass the parameter in a single quote rather than in double-quotes. In this way, your query should execute successfully in the Raw SQL step also.
[img]att1[/img]
Howdy, Stranger!
Categories
- 4.4K All Categories
- 86 General
- 13 Training
- 212 Installation / Setup
- 1.2K Flows
- 112 Rules
- 282 Administration
- 216 Portal
- 501 General Q & A
- 719 Forms
- 353 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 189 Pages
- 5 Process Mining
- New Features
- 187 Datastructures
- 71 Repository
- 233 Integrations
- 30 Multi-Tenant
- 27 SDK
- 81 Modules
- 60 Settings
- 27 Active Directory
- 12 Version 7
- 36 Version 8
- 143 Lunch And Learn Questions