Retrieving relationship instances

Perform the following steps to retrieve relationship instances or to return a count of how many instances there are for a relationship:

  1. Make sure Relationship Manager is connected to a server. Follow the instructions in Connecting Relationship Manager to a InterChange Server Express.
  2. In Relationship Manager, click File > Retrieve.
    The Retrieve Relationship Instances dialog box (displayed below) opens.

    Retrieve Relationship Instances dialog box in Relationship Manager

  3. You can perform the following operations with the Retrieve Relationship Instances window:

    The Retrieve Relationship Instances window is also displayed when you specify a relationship to open when connecting to InterChange Server Express.

    Depending on the number of participants in the relationship definition and the number of participant instances in each relationship instance, these retrieval queries may take some time.

    Retrieving all instances for a relationship

    Perform the following steps to retrieve the first 500 instances for a relationship:

    1. At the Retrieve Relationship Instances window click Retrieve All.
    2. Click Get Instances.
      Relationship Manager displays the first 500 instances for the relationship.

    Retrieving instances by relationship ID

    Perform the following steps to retrieve a range of up to 500 instances by relationship ID:

    1. At the Retrieve Relationship Instances window click Retrieve by ID.
    2. Type the ID of the first instance in the range you want to retrieve in the From field.
    3. Type the ID of the last instance in the range you want to retrieve in the To field.
    4. Click Get Instances.
      Relationship Manager displays up to 500 instances in a range of the IDs specified.

    Retrieving relationship instances by participant data

    Perform the following steps to retrieve a relationship instance based on values for key or non-key attributes of selected participants:

    1. At the Retrieve Relationship Instances window click Retrieve by Value.
    2. Select the participant whose value you want to search on from the Participants list.
      For identity relationships, participant names are followed by the business object definition with which the participant is associated.
      For lookup relationships, participant names followed by the word "Data".
    3. Type one of the types of values listed in the table below in the Value column in the Attributes pane.
      Supported values for retrieving relationship instances by participant data
      Value Description
      Participant data The data of the selected participant.

      For example, if the relationship is an identity relationship you would specify the ID of the participant instance that you know to find the relationship instance in which it exists.

      If the relationship is a lookup relationship you would specify the non-key data value of the participant instance.

      %

      Any string of characters. This option is case-sensitive; numbers are included in the character set.

      For example, if %A were specified for a participant that stores abbreviated forms of the names of the United States, the values CA, GA, IA, LA, MA, PA, VA, and WA would be returned.

      _

      Any single character.

      As an example, _00 would retrieve 100, 200, a00, b00, and so forth.

    4. Click Get Instances.
      Relationship Manager displays the first 500 relationship instances that match the specified value.

    Returning a count of relationship instances

    Perform the following steps to return the number of relationship instances that satisfy a retrieval criteria:

    1. Select the options for the criteria as described in Retrieving all instances for a relationship, Retrieving instances by relationship ID, or Retrieving relationship instances by participant data.
    2. Click Get Count (instead of Get Instances).

    See also:

    Relationship Manager overview

    Working with relationships in Relationship Manager

    Working with relationship data in Relationship Manager


    [ Top of Page | Previous Page | Next Page | Table of Contents ]

    Copyright IBM Corp. 2004