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.5K All Categories
- 87 General
- 13 Training
- 213 Installation / Setup
- 1.2K Flows
- 112 Rules
- 277 Administration
- 215 Portal
- 503 General Q & A
- 722 Forms
- 356 Reports
- 3 Designer Extensions
- 47 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 8 Javascript Controls
- 190 Pages
- 5 Process Mining
- New Features
- 187 Datastructures
- 72 Repository
- 238 Integrations
- 30 Multi-Tenant
- 27 SDK
- 81 Modules
- 60 Settings
- 26 Active Directory
- 12 Version 7
- 37 Version 8
- 143 Lunch And Learn Questions