Share this page

# MREL_REFERENCES

Used to view the references of releases in Deployment Management.

There are several types of references for releases. If a package is part of a release, then there will be a reference for that package. Similarly, if a request is part of a release, then there will be a reference for that request. Releases can be designated as children or parents of other releases through the use of references. References are also used to attach documents to a release.

The RELATIONSHIP column in MREL_REFERENCES describes the relationship of the referenced item to the release that references it. This view also has columns for each of the entities that can be referenced to a release: other releases, requests, packages, attachments, and URLs.

For each record in MREL_REFERENCES, only one of these columns will have a value and the others will be NULL.

Sample

To retrieve a list of all references to a particular release:

    SELECT referenced_release_id REL,
           referenced_package_id PKG,
           referenced_request_id REQ,
           attachment_name       ATTACHMENT,
           document_url          URL,
           relationship          RELATIONSHIP
    FROM   mrel_references
    WHERE  release_name = 'FIN Apps Prod Release';

Results

    REL   PKG   REQ   ATTACHMENT           URL           RELATIONSHIP
    ----- ----- ----- -------------------- -------------- ---------------------
    30012                                                 Parent Release
                      finAppsRelease.doc
    42764                                                 Contained in this Release
    42765                                                 Contained in this Release
    42772                                                 Contained in this Release
    42773                                                 Contained in this Release
    42774                                                 Contained in this Release
    42778                                                 Contained in this Release

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: