Perform the following steps to retrieve relationship instances or to return a count of how many instances there are for a relationship:
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.
Perform the following steps to retrieve the first 500 instances for a relationship:
Perform the following steps to retrieve a range of up to 500 instances by relationship ID:
Perform the following steps to retrieve a relationship instance based on values for key or non-key attributes of selected participants:
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.
|
Perform the following steps to return the number of relationship instances that satisfy a retrieval criteria:
See also:
Working with relationships in Relationship Manager
Working with relationship data in Relationship Manager