Subversion Repositories DevTools

Rev

Rev 5506 | Rev 5898 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 5506 Rev 5596
Line 30... Line 30...
30
             3 AS priority,
30
             3 AS priority,
31
             'ERROR' AS products_msg
31
             'ERROR' AS products_msg
32
        FROM PACKAGE_VERSIONS pv
32
        FROM PACKAGE_VERSIONS pv
33
       WHERE pv.pv_id = :PV_ID
33
       WHERE pv.pv_id = :PV_ID
34
         AND pv.build_type = 'A'
34
         AND pv.build_type = 'A'
35
         AND pv.vcs_type_id IN (SELECT vt.vcs_type_id FROM vcs_type vt WHERE vt.tag = 'UC')
35
         AND pv.vcs_type_id IN (SELECT vt.vcs_type_id FROM vcs_type vt WHERE vt.tag = 'UC' OR vt.tag = 'CVS')
36
 
36
 
37
 
37
 
38
      UNION
38
      UNION
39
 
39
 
40
      /* ------- ERROR: Package Information Section Incomplete ------- */
40
      /* ------- ERROR: Package Information Section Incomplete ------- */
Line 44... Line 44...
44
             10 AS priority,
44
             10 AS priority,
45
             'ERROR' AS products_msg
45
             'ERROR' AS products_msg
46
        FROM PACKAGE_VERSIONS pv
46
        FROM PACKAGE_VERSIONS pv
47
       WHERE pv.pv_id = :PV_ID
47
       WHERE pv.pv_id = :PV_ID
48
         AND (    pv.PV_DESCRIPTION IS NULL
48
         AND (    pv.PV_DESCRIPTION IS NULL
-
 
49
			   OR Length(pv.PV_DESCRIPTION) < 1
49
               OR pv.PV_OVERVIEW IS NULL
50
               OR pv.PV_OVERVIEW IS NULL
-
 
51
 			   OR Length(pv.PV_OVERVIEW) < 1
50
               OR pv.IS_BUILD_ENV_REQUIRED IS NULL
52
               OR pv.IS_BUILD_ENV_REQUIRED IS NULL
51
             )
53
             )
52
 
54
 
53
      UNION
55
      UNION
54
 
56