Begin by navigating to the Query page.
Click the Reporting Tools link.Step 1
Click the Query Manager link.Step 2
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
Click the Search button.Step 4
Click an entry in the Edit column.Step 5
Click the Query tab.Step 6
Use the Query page to add fields to the query content.
You can also add additional records by performing joins.Step 7
Note that the base record in this example is Application Message Definition with the appropriate fields and criteria.Step 8
Use the Hierarchy Join link to join parent-child records.
Click the Hierarchy Join link.Step 9
Use the Select record for hierarchy join page to join a parent table to a child table.Step 10
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
The join is reflected on the Query page:
• Record A is Application Message Definition.
• Record B is Message Definition Record.Step 12
Select the Sequence Number field for the second record.
Click the Sequence Number option.Step 13
Select the Message Name field for the second record.
Click the Message Name option.Step 14
Click the Save button.Step 15
You have successfully created a record hierarchy join.
Table of Contents Start Topic