Share this page

# MREQ_REFERENCES

Used to view the references of requests in Demand Management.

There are several types of references for requests. If a request is part of a release, then there will be a reference for that release. If a request is a parent or child of another request, then there will be a reference for that request. References are also used to attach documents to a request.

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

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

Sample

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

    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   mreq_references
    WHERE  request_number = '54872';

Results

    PKG  PROJ  REQ   REL  TASK   ATTACHMENT       URL         RELATIONSHIP
    --- ----- ----- ----- ----- ------------ ---------- ---------------------------
                          43301                               Contains this Request                        43304                               Contains this request
    30043                                                     Child of this Request
              52383                                           Parent of this Request
                                screenShot.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: