Subversion Repositories DevTools

SELECT *
  FROM  (
  
           
        /* ------- ERROR: SBOM Priority Section Incomplete ------- */   
        SELECT DISTINCT 'enum_MSG_PACKAGE_SBOMPRIORITY_INCOMPLETE' AS err_message,
                        'fixed_issues.asp' AS rfile,
                        '#SBOM_PRIORITY' AS anchor,
                        1 AS priority,
                        'ERROR' AS products_msg
                   FROM PACKAGE_VERSIONS pv
                  WHERE pv.pv_id = :PV_ID
                    AND ( pv.SBOM_PRIORITY IS NULL )

        UNION                            

        /* ------- ERROR: Package is unbuildable ------- */
        SELECT DISTINCT 'enum_MSG_UNBUILDABLE_PACKAGE' AS err_message,
               'fixed_issues.asp' AS rfile,
               '#PACKAGE_INFORMATION' AS anchor,
               2 AS priority,
               'ERROR' AS products_msg
         FROM  PACKAGE_VERSIONS pv
         WHERE pv.pv_id = :PV_ID
           AND pv.build_type  = 'U'

         
        ) errmsg
ORDER BY priority