This documentation supports the 21.02 version of BMC Helix Innovation Studio.

To view an earlier version, select the version from the Product version menu.

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.


Application business analysts can customize the objects developed in their own applications and that are marked customizable by the administrator, but cannot customize the objects developed in com.bmc.arsys in Best Practice Customization mode. For example, objects in core BMC applications like Foundation, Approval, and Assignment cannot be customized in Best Practice Customization mode.

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.


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

    The following table provides information about the properties:

    Primary recordThe main record for combining the data.
    Secondary recordThe 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.
Was this page helpful? Yes No Submitting... Thank you