Create Select Query Issues
Comments
- 
            
I have a flow where the user inputs an email id in one form and then uses that email id in a where clause (Raw query) that creates “Results” as data rows in the form of none, one or many rows.
How can I show the data rows in a form with the results from the query?
 - 
            
You might be able to use a datagrid in a form and set it to use Datarow type. Otherwise, youd have to map the result set to a data structure before passing into the form, if that makes sense
 - 
            
Basically, I am trying to get a list that I can choose an entry that links me to a form that will display detail info
 - 
            
Thank you for the additional info. It sounds like you want to use an Access Pattern here. Can you take a look at the following document and see if it fits your use case?
https://documentation.decisions.com/v6/docs/alternate-access-pattern-table-integrations
 - 
            
This is perfect, thank you!
 
Howdy, Stranger!
Categories
- 4.5K All Categories
 - 88 General
 - 13 Training
 - 214 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
 - 73 Repository
 - 238 Integrations
 - 30 Multi-Tenant
 - 27 SDK
 - 81 Modules
 - 60 Settings
 - 27 Active Directory
 - 12 Version 7
 - 37 Version 8
 - 143 Lunch And Learn Questions