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_SEC_MENU_PLIST 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 Menu Definition and Authorized Menu Item with the appropriate fields and criteria.
In this example, you want to join the Menu Name field of the Authorized Menu Item record.
Click the Authorized Menu Item record object.Step 8
Click the Join PSMENUDEFN - Menu Definition link.Step 9
Use the Select join type page to define the type of join. The available options are Standard Join and Left Outer join.Step 10
In this example, you will select the Standard Join option.
Click the Standard Join option.Step 11
Click the OK button.Step 12
The join is reflected on this Query page.
Select the Installed and Description fields for the third record.
Click the Installed option.Step 13
Click the Description option.Step 14
Click the Save button.Step 15
You have successfully created related record join.
Table of Contents Start Topic