Creating advanced associations between classes

Improve the functionality of the class association feature by providing users with advanced options for creating complex associations between classes. For example, you can associate two classes whose properties do not share a common value, by joining them with a separate class to fetch the data from all the three classes. For example, when you associate the Work- and the Data-Admin-OrgUnit classes, you can define a corresponding join between them by adding the Assign-Worklist class to the association. Associations provide the option to join the Work- class with the Assign-Worklist class, and then the Assign-Worklist class with the Data-Admin-OrgUnit class.
  1. Create an association record by following steps 1 through 2 in Creating simple associations between classes.
  2. At the top of the New tab, click Convert to advanced configuration, and then confirm the conversion by clicking Submit.
  3. In the Class association section, in the Class name field, specify the class that you want to associate with the context class.
    You specify the context class in the Apply to (class) field when you create an association record.
  4. Create a class join between classes:
    1. In the Class join section, click Add class join.
    2. In the Prefix field, enter a short alias for the class that you want to join with the context class.
      The prefixes help the system to distinguish classes and ensure that classes are joined accurately.

      For example, enter A.

    3. In the Class name field, enter the class that you want to join with the context class.
    4. Click Edit conditions.
    5. In the Column field, enter the prefix of the class that you want to join, and then specify a property of that class.
      For example, if you set the prefix as A, enter A.pyLabel.
    6. In the Relationship Value field, enter a property of the context class, and click Submit.
      Result: The system creates a join between the context class and the joined class.
  5. Depending on the complexity of your association, create additional joins between classes by repeating step 4 to create a connection between the context class, and the secondary class.
  6. In the Type list, select the type of join to use.
    For example, select Only include matching rows to include rows that contain common data for both classes.
  7. In the upper-right corner of the New tab, click Save.