Creating join record definitions

You create a join record definition to combine data that is retrieved from multiple record definitions. The join record definitions are similar to database joins.

Before you begin

Before you create and manage record definitions, ensure that you have created a project and deployed it in BMC Helix Innovation Studio. For more information, see Creating-a-Project-using-Maven-and-the-Archetype.

To create a join record definition

1. Log in to the BMC Helix Innovation Studio and navigate to the Workspace tab. 
2. Select the application for which you need to create the join record.
3. On the Records tab, click New and select Join Record.
   The Create New Join Record window appears as shown in the following image:
   

4. On the Record Definitions tab, specify the properties for the record definition.

   Note

   The Application/Library scoped definitions are marked with an asterisk ( * ).

   The following table provides information about the properties:

   Field	Description
   Primary record	The main record for combining the data.
   Secondary record	The secondary record for combining the data.
   Join type	The type of join for the record definition. You can select either of the join record types: Inner join—Selects entries only when corresponding values exist in both records. Outer join—Includes all of the entries from the record that you select as primary, even entries for which there are no matching entries in the secondary record.

    

5. On the Join Criteria tab, specify the expression for joining the records, and click Next.The query for joining the records is restricted to the conditions specified in the expression.
6. On the Field Selection tab, select the fields from the primary and secondary records that you need to include in the join record, and click Save.
   The following image shows the Field Selection tab:
   
7. Save the record.

Related topic

Creating-or-modifying-regular-record-definitions