Working with relationship data

An important feature of Relationship Manager is its ability to access and manipulate relationship run time data contained in the relationship tables. The following topics describe how to use Relationship Manager to manipulate and access run time data:

Steps for searching for participants

Steps for filtering the displayed participants

Steps for cleaning up participants

Steps for printing relationship data

Steps for searching for participants

You can search for participant instances based on different criteria. Depending on how specific your search criteria is, your searches can locate a unique participant instance or a group of participant instances. You can find participant instances either by business object or by data.

Steps for finding instances by business object

This option searches for instances whose data type is an attribute in a business object.

Perfom the following steps to search for instances by business object:

  1. Select a participant instance in Relationship Manager.
  2. Select Edit > Find Instances by Business Object from the menu bar.

    The Find Instances by Business Object window appears (see Figure 38).

    Figure 38. Find Instances by Business Object

    The figure shows the dialog box for finding instances using the business object as a criteria. This box includes a field for entering the business object definition, including attribute name, type and value.

  3. Type the participant value by which you want to search in the Value cell.
  4. Click OK.

    Relationship Manager displays any matching instances in a dialog box.

  5. Double-click any of the instances in the dialog box displayed by Relationship Manager to navigate to and highlight the instance.

Steps for finding instances by data

This option searches for instances whose type is Data.

Perfom the following steps to search for instances by data:

  1. Select a participant instance in Relationship Manager.
  2. Select Edit > Find Instances by Data from the menu bar.

    Relationship Manager displays the "Find Instances by Data" window, as shown in Figure 39.

    Figure 39. Finding instances by data

    The figure shows the dialog box for finding instances using data as a criteria. This box includes a field for entering the data.

  3. Type the participant value by which you want to search in the Enter the data cell.
  4. Click OK.

    Relationship Manager displays any matching instances in a dialog box.

  5. Double-click any of the instances in the dialog box displayed by Relationship Manager to navigate to and highlight the instance.

Steps for filtering the displayed participants

You can filter the participants to only display those created or modified between certain dates. Perform the following steps to filter the displayed participants:

  1. Select a participant in Relationship Manager.
  2. Select View > Filter from the menu bar.

    Relationship Manager displays the "Filter" dialog box, as shown in Figure 40.

    Figure 40. Filtering participant results

    The figure shows the dialog box for screening participants created of modified by enter information on two lines. The top line determines the from date, specifically month, day, year, and time. The bottom line determines the to date. there is also a check box to include inactive participants in the list.

  3. In the "Filter" dialog box, enter the earliest date of creation or modification for the participant in the from field and the latest date of creation or modification for the participant in the to field.

    Use the following techniques to enter the date value:

  4. Select the Include inactive participants as well check box if you want to include inactive participants in the resulting display.
  5. Click OK.

    Relationship Manager displays the history of activity for the filtered interval in the "Filter Results" dialog box. The filtered display includes inactive participants if the Include inactive participants as well option box is checked. Figure 41 shows the "Filter Results" dialog box.

    Figure 41. Viewing filtered participant data

    The figure shows the filtered participants results in table format, including the relation participant, the type, the value, the date modified and the action taken.

Steps for cleaning up participants

Perform the following steps to clean up participants due to inconsistent or corrupt data in the source application or generic object:

  1. Select a participant in Relationship Manager.
  2. Select Edit > Clean Up Participants from the menu bar.

    Relationship Manager displays the "Clean up Participants" dialog box, as shown in Figure 42.

    Figure 42. Cleaning up participants

    The figure shows the dialog box for cleaning up participants in a current relationship, with one line determines the from date, specifically month, day, year, and time.

  3. In the "Clean Up Participants" dialog box, enter the date to which you want to revert the participant values to in the Clean up from field.

    Use the following techniques to enter the date value:

  4. Click OK.

    All participant adds, deactivations, and activations since that point in time are erased from the database. A participant that has been deleted or whose value has been modified cannot be cleaned up.

Steps for printing relationship data

Relationship Manager allows you to print information about a relationship's run time data. It creates a tree representation of the run time data, much like the data appears in the tool's main window. The printing command of Relationship Manager sends the current contents of the relationship tree in the main window to the printer.

Perform the following steps to print relationship run time data:

  1. Expand the relationship tree of Relationship Manager so that the information you want to print is displayed.
  2. If you want to print only a portion of the relationship instances, select only those instances by highlighting them.
  3. Print relationship run time data in any of the following ways:
  4. The Print Relationship Instances dialog box appears. Select either "all instances" or "selected instances," then click OK.

Copyright IBM Corp. 1997, 2004