Web Designer - Collection with data from multiple tables

Wanting to create a collection that will hold data from multiple tables.  Saw the following type of collection "Database objects from multiple tables", but was not sure how to use it.  Can anyone enlighten?  We are using version 7.1.2.

  • I would also like to know. Curious where/how to do the JOIN.

  • Hi,

    Quoting from the documentation file (OneIM_QER_WebDesignerModel.chm)

    For some use cases, the type of database objects is not known until runtime. There are also situations in where database objects from more than one database table must be processed together. In these scenarios, this collection type can be used. Compared with the Database object collection type, this collection type has one major limitation: It is not possible to reference any columns from any one specific database table.
    For example, you could load Department-typed and Locality-type objects into one collection.
    You can use a "Load collection" action  to load data into a collection of this type. For more obscure use cases, use the "fill collection" action. It really depends on what you are trying to achieve.
    Hope this helps,
    Hanno