Share this page

# MPKG_NOTES

Provides access to the notes for all packages in Deployment Management.

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

To query package notes, join this view with the MPKG_ALL_PACKAGES view.

Sample

To retrieve a list of the notes for all open packages being processed through the FIN dev -> prod workflow, and that have Critical priority, use the following logic in an SQL statement:

    SELECT p.package_number PKG_NUM,
           n.NOTE_DATA NOTES
    FROM   mpkg_packages p,
           mpkg_notes n
    WHERE  p.priority = 'Critical'
    AND    p.workflow = 'FIN dev -> prod'
    AND    p.package_id = n.package_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: