Export Project Item List to Markdown

SELECT '- '
    || RTRIM(
           RTRIM(
               DECODE(B.OBJECTTYPE,
                   0,   'Record',
                   1,   'Index',
                   2,   'Field',
                   3,   'Format Definition',
                   4,   'Translate',
                   5,   'Page',
                   6,   'Menu',
                   7,   'Component',
                   8,   'Record PeopleCode',
                   9,   'Menu PeopleCode',
                   10,  'Query',
                   11,  'Tree Structure',
                   12,  'Tree',
                   13,  'Access Group',
                   14,  'Color',
                   15,  'Style',
                   16,  'Not Used',
                   17,  'Business Process',
                   18,  'Activity',
                   19,  'Role',
                   20,  'Process Definition',
                   21,  'Process Server',
                   22,  'Process Type',
                   23,  'Process Job',
                   24,  'Process Recurrence',
                   25,  'Message',
                   26,  'Dimension',
                   27,  'Analysis Model',
                   28,  'Cube Template',
                   29,  'Business Interlink',
                   30,  'SQL Object',
                   31,  'File layout Definition',
                   32,  'Component Interface',
                   33,  'App Engine Program',
                   34,  'App Engine Section',
                   35,  'Message Node',
                   36,  'Message Channel',
                   37,  'Message Definition',
                   38,  'Approval rule set',
                   39,  'Message PeopleCode',
                   40,  'Subscription PeopleCode',
                   41,  'Not Used',
                   42,  'Component PeopleCode',
                   43,  'Application Engine PeopleCode',
                   44,  'Page PeopleCode',
                   45,  'Page Field PeopleCode',
                   46,  'Component PeopleCode',
                   47,  'Component Record PeopleCode',
                   48,  'Component Record Field PeopleCode',
                   49,  'Image',
                   50,  'Style Sheet',
                   51,  'HTML Catalog',
                   52,  'Not Used',
                   53,  'Permission List',
                   54,  'Portal Registry Definition',
                   55,  'Portal Registry Structure',
                   56,  'URL Definitions',
                   57,  'Application Package',
                   58,  'Application Package PeopleCode',
                   59,  'Portal Registry User Homepage',
                   60,  'Problem Type Definition',
                   61,  'Data Archival',
                   62,  'XSLT',
                   63,  'Portal Registry User Favorite',
                   64,  'Mobile Page',
                   65,  'Relationship',
                   66,  'Component Interface Property PeopleCode',
                   67,  'Optimization Model',
                   68,  'File Reference',
                   69,  'File Reference Type Code',
                   70,  'Archive Objects',
                   71,  'Archive Templates',
                   72,  'Diagnostic Plug-In',
                   73,  'BAM Model',
                   74,  'Not Used',
                   75,  'Java Portlet User Preferences',
                   76,  'WSRP Remote Producer',
                   77,  'WSRP Remote Portlet',
                   78,  'WSRP Cloned Portlet Handle',
                   79,  'Service',
                   80,  'Service Operation',
                   81,  'Service Operation Handler',
                   82,  'Service Operation Version ',
                   83,  'Service Operation Routing',
                   84,  'Queue Defintion Handle',
                   85,  'XMLP Template Defn Manager',
                   86,  'XMLP Report Defn Manager',
                   87,  'XMLP File Manager',
                   88,  'XMLP Data Src Manager',
                   89,  'WSDL Manager',
                   90,  'Message Schemas',
                   91,  'Connected Queries Defn Manager',
                   92,  'Logical Schema',
                   93,  'XML Schema',
                   94,  'Relational Schema',
                   95,  'Dependency Document',
                   96,  'Document Schema',
                   97,  'Essbase Cube Dimension Manager',
                   98,  'Essbase Cube Outline Manager',
                   99,  'Essbase Cube Connection Manager',
                   100, 'Essbase Cube Template Manager',
                   101, 'Delimited Schema',
                   102, 'Positional Schema',
                   103, 'Application Data Set Definition Manager',
                   104, 'Test Framework Manager',
                   105, 'Test Framework Test Case Manager',
                   106, 'Application Data Set Binding',
                   256, 'Invalid Object Type',
                   107, 'Feed Definition Manager',
                   108, 'Feed Category Manager',
                   109, 'Feed Data Type Manager',
                   110, 'Json Schema ',
                   111, 'Related Content Service Defintion Manager',
                   112, 'Related Content Service Manager',
                   113, 'Related Content Service Config Manager',
                   114, 'Related Content Layout Manager',
                   115, 'PTSF Search Attribute ',
                   116, 'PTSF Search Definition ',
                   117, 'PTSF Search Category ',
                   118, 'PTSF Search Context ',
                   119, 'Integration Group Manager',
                   120, 'Html Schema ',
                   121, 'Document Layout Manager ',
                   122, 'Document Template Manager ',
                   123, 'Composite Query Manager',
                   124, 'Document PeopleCode Manager',
                   125, 'MAP Admin Manager',
                   'unknown-object-type')
               || ': '  || B.OBJECTVALUE1
               || '-'   || TRIM(B.OBJECTVALUE2)
               || '-'   || TRIM(B.OBJECTVALUE3)
               || '-'   || TRIM(B.OBJECTVALUE4)
           )
       , '-')         AS project_item_line
FROM   PSPROJECTDEFN A
INNER JOIN PSPROJECTITEM B
    ON A.PROJECTNAME = B.PROJECTNAME
WHERE  B.PROJECTNAME = '{{ REPLACE_WITH_YOUR_PROJECT_NAME }}'
ORDER BY 1;