Joining Two Objects To Be Displayed On A Form
  • 12 Mar 2021
  • 1 Minute to read
  • Dark
    Light

Joining Two Objects To Be Displayed On A Form

  • Dark
    Light

Article summary

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

Version6.10.1
Root FolderExampleLab.TwoObjectJoin
Modules None
DependenciesNone

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.





Was this article helpful?