Share this page

# MPKG_REFERENCES

References are used throughout PPM to relate transaction entities together. The MPKG_REFERENCES view can be used to view the references of packages in Deployment Management.

There are several types of references for packages. If a package is part of a release, then there will be a reference for that release. If a package was spawned by a request, then there will be a reference for that request. Packages can be related to other packages through the use of references. References are also used to attach documents to a package.

The RELATIONSHIP column in MPKG_REFERENCES describes the relationship of the referenced item to the package that references it. This view also has columns for each of the entities that can be referenced to a package—other packages, projects, tasks, requests, releases, attachments, and URLs. For each record in MPKG_REFERENCES, only one of these columns will have a value and the others will be NULL.

Sample

The following SQL statement can be used to retrieve a list of all references to a particular package:

    SELECT referenced_package_id PKG,
           referenced_project_id PROJ,
           referenced_request_id REQ,
           referenced_release_id REL,
           referenced_task_id    TASK,
           attachment_name       ATTACHMENT,
           document_url          URL,
           relationship          RELATIONSHIP
    FROM   mpkg_references
    WHERE  package_number = '30121';

Results

    PKG  PROJ   REQ  REL  TASK   ATTACHMENT       URL       RELATIONSHIP
    ---- ----- ----- ---- ----- ---------------- ---------- ---------------------
                     30012                                  Contains this Package
    30332                                                   Run after this Package
    30043                                                   Run before this Package
    30044                                                   Run before this Package
    30046                                                   Run before this Package

                                 design32_3.doc

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: