Creating Related Record 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_SEC_MENU_PLIST query.

     

    Enter the desired information into the begins with field. Enter

     a valid value
     e.g.
     "pt_sec_menu"
    .

    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 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
  9. Click the Join PSMENUDEFN - Menu Definition link.

    Step 9
  10. Use the Select join type page to define the type of join. The available options are Standard Join and Left Outer join.

    Step 10
  11. In this example, you will select the Standard Join option.

     

    Click the Standard Join option.

    Step 11
  12. Click the OK button.

    Step 12
  13. The join is reflected on this Query page.

     

    Select the Installed and Description fields for the third record.

     

    Click the Installed option.

    Step 13
  14. Click the Description option.

    Step 14
  15. Click the Save button.

    Step 15

You have successfully created related record join.

Table of Contents  Start Topic