Creating Record Hierarchy Joins


Concept


Steps:

  1. Begin by navigating to the Query page.

     

    Click the Reporting Tools link.

    Step 1
  2. Click the Query Manager link.

    Step 2
  3. In this example, you will search for the PT_CHNLS_MSGS_AT_A_NODE query.

     

    Enter the desired information into the begins with field. Enter

     a valid value
     e.g.
     "PT_"
    .

    Step 3
  4. Click the Search button.

    Step 4
  5. Click an entry in the Edit column.

    Step 5
  6. Click the Query tab.

    Step 6
  7. Use the Query page to add fields to the query content.

     

    You can also add additional records by performing joins.

    Step 7
  8. Note that the base record in this example is Application Message Definition with the appropriate fields and criteria.

    Step 8
  9. Use the Hierarchy Join link to join parent-child records.

     

    Click the Hierarchy Join link.

    Step 9
  10. Use the Select record for hierarchy join page to join a parent table to a child table.

    Step 10
  11. All of the records that have a parent/child relationship with the selected record appear on this page.

     

    In this example, select the Message Definition Record record for the join.

     

    Click the Message Definition Record link.

    Step 11
  12. The join is reflected on the Query page:

    •   Record A is Application Message Definition.

    •   Record B is Message Definition Record.

    Step 12
  13. Select the Sequence Number field for the second record.

     

    Click the Sequence Number option.

    Step 13
  14. Select the Message Name field for the second record.

     

    Click the Message Name option.

    Step 14
  15. Click the Save button.

    Step 15

You have successfully created a record hierarchy join.

Table of Contents  Start Topic