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.10.1 |
| Root Folder | ExampleLab.TwoObjectJoin |
| Modules | None |
| Dependencies | None |
This project serves as an example of joining two database stored structures together to be displayed on a Form in a data grid.
Explanation
This Flow will use a RawSQL Join to combine two database stored objects into a simple Flow structure. In order to make this join successful, we have added an ID field to both of our structures that will save a relating ID when the items are created. Once items are paired and the resulting structure is built, the structure will then be passed to the Form to be displayed on a data grid component. This project contains a set up flow, which will need to be run prior to the Main Flow. This stages data on the database in order for the join to be successful.
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.10.1 or later using our Importing/Exporting article.