Using String List in Raw SQL Step
- 12 Mar 2021
- 1 Minute to read
- Print
- DarkLight
Using String List in Raw SQL Step
- Updated on 12 Mar 2021
- 1 Minute to read
- Print
- DarkLight
Article Summary
Share feedback
Thanks for sharing your feedback!
Example Lab Article
While Example Lab projects are resources for public use, articles and assets are not actively maintained. Screenshots and features are from the specified version below. These references may become dated as new versions are released.
Overview
Example Lab Details | |
| Version | 6.5.0 |
| Root Folder | Example Lab - List in SQL |
| Modules | None |
| Dependencies | None |
This Example Lab demonstrates the ability for a Flow to take in a String List and Table Name in order to use the "Where In" SQL command, on the Raw SQL Step.
Explanation
This Flow takes in a String List and a Table in order to use the SQL command 'Where In' on the Accounts Table. This list goes through a For Each Loop were the List is converted to a properly formatted string for the Raw SQL Command to take.
Reference Articles
Project Download
The examples attached were developed to be instructional and were not developed as officially supported components. For more information or to engage our service team to develop fully supported, production quality solutions, please contact services@decisions.com. Import the project below to a Decisions environment on version 6.5.0 or later using our Importing/Exporting article.
Was this article helpful?
