Creating Root Collection Joins

Use the joins feature to join related data that exists in more than one root collection.

You would typically use this feature to join collections that have been converted from external non-object-oriented databases (for example, from a relational database), although it must be emphasized that a well-designed JADE system that makes full use of JADE’s relationship protocols would normally remove the need to create collection joins.

An example of using joins would be a situation in which you had two collections containing names and addresses (for example, a collection of agents and a collection of clients).

If you wanted to produce a report of people who appeared in both collections, you could join these collections in the JADE Report Writer Configuration application. The data would effectively become one list in the JADE Report Writer Designer application, from which your report designers could select fields for inclusion in their reports.

Use the Joins sheet of the JADE Report Configuration window to create and maintain joins.

To access the Joins sheet

• Click on the Joins tab of the JADE Report Configuration window.

The Joins sheet, shown in the following image, is then displayed.

Creating joins is further described in the following subsections.

• Selecting the Collections to Join

• Selecting the Fields to Join

• Creating Selection Criteria for Your Join