Share this page

# MREQ_NOTES

Provides access to the notes for all requests in Demand Management.

Notes are stored in an Oracle LONG database column; to prevent an overload of information this was presented in a separate Meta Layer view, making it less likely to design a report that inadvertently returns too much data.

To query request notes, join this view with a request view (MREQ_REQUESTS, or a request type-specific view MREQ_<Request Type Name>).

Sample

To retrieve a list of the notes for all open requests of the Bug request type, that have Critical priority, use the following logic in an SQL statement:

    SELECT r.request_number REQ_NUM,
           n.notes NOTES
    FROM   mreq_bug r,
           mreq_notes n
    WHERE  r.priority = 'Critical'
    AND    r.request_id = n.request_id;

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: