RAW SQL Step Throwing Error?

in Flows
Greetings,
I'm using a RAW SQL step to fetch accounts based upon certain criteria. However, when I began testing, I was running into an error as soon as I add any sort of "WHERE" clause. The error is something like "Error message: Invalid column name". I'm trying to connect to an SQL DB. Am I doing something wrong? Here's what test query looks like:
Comments
-
Hello!
That error message is most likely indicative of a syntax error. You'll want to be sure you use single quotes around variables (even those passed-in from the flow) when making a SQL query. Your query should run if you were to type this:
SELECT * FROM entity_account
WHERE account_id = 'your variable'
Hope this helps!
-Gregory
Howdy, Stranger!
Categories
- 4.3K All Categories
- 69 General
- 11 Training
- 206 Installation / Setup
- 1.1K Flows
- 108 Rules
- 266 Administration
- 212 Portal
- 495 General Q & A
- 704 Forms
- 335 Reports
- 3 Designer Extensions
- 47 Example Flows
- 56 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 184 Pages
- 5 Process Mining
- New Features
- 181 Datastructures
- 69 Repository
- 227 Integrations
- 28 Multi-Tenant
- 27 SDK
- 81 Modules
- 57 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 112 Lunch And Learn Questions