Subversion Repositories DevTools

Rev

Rev 119 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 119 Rev 5377
Line -... Line 1...
- 
 
 1 
-- =====================================================
1 
/* User Wip */
 2 
-- UserWip.sql
- 
 
 3 
-- Keep in step with 'WorkInProgressByUser.sql'
- 
 
 4 
--
- 
 
 5 
--   Used by index.asp to list Releases and Package Versions
- 
 
 6 
--   that the user is working on
- 
 
 7 
-- =====================================================
2 
SELECT pr.PROJ_NAME ||' / '|| rt.RTAG_NAME  AS LOCATION,
 8 
SELECT pr.PROJ_NAME ||' / '|| rt.RTAG_NAME  AS LOCATION,
3 
	   pkg.PKG_NAME,
 9 
       pkg.PKG_NAME,
4 
	   rel.PKG_VERSION,
 10 
       rel.PKG_VERSION,
5 
	   rel.PV_ID,
 11 
       rel.PV_ID,
6 
	   rt.RTAG_ID
 12 
       rt.RTAG_ID
7 
  FROM (
 13 
  FROM (
8
14
9 
  		/* Get WIP Packages */
 15 
        /* Get WIP Packages */
10 
        SELECT wip.PV_ID, rt.RTAG_ID, pv.PKG_ID, pv.PKG_VERSION
 16 
        SELECT wip.PV_ID, rt.RTAG_ID, pv.PKG_ID, pv.PKG_VERSION
11 
		  FROM WORK_IN_PROGRESS wip,
 17 
          FROM WORK_IN_PROGRESS wip,
12 
		  	   RELEASE_TAGS rt,
 18 
               RELEASE_TAGS rt,
13 
			   PACKAGE_VERSIONS pv
 19 
               PACKAGE_VERSIONS pv
14 
		 WHERE wip.RTAG_ID = rt.RTAG_ID
 20 
         WHERE wip.RTAG_ID = rt.RTAG_ID
15 
		   AND rt.OFFICIAL != 'Y'
 21 
           AND rt.OFFICIAL IN ('N','R','C')
16 
		   AND wip.PV_ID = pv.PV_ID
 22 
           AND wip.PV_ID = pv.PV_ID
17 
		   AND pv.DLOCKED != 'Y'
 23 
           AND pv.DLOCKED != 'Y'
18 
		   AND pv.MODIFIER_ID = :USER_ID
 24 
           AND pv.MODIFIER_ID = :USER_ID
19
25
20 
		UNION
26 
        UNION
21
27
22 
		/* Get WIP Patches */
 28 
        /* Get WIP Patches */
23 
        SELECT pp.PATCH_ID AS PV_ID, rt.RTAG_ID, pv.PKG_ID, pv.PKG_VERSION
 29 
        SELECT pp.PATCH_ID AS PV_ID,rt.RTAG_ID,pv.PKG_ID,pv.PKG_VERSION
24 
		  FROM RELEASE_CONTENT rc,
 30 
         FROM RELEASE_CONTENT rc,
25 
		  	   RELEASE_TAGS rt,
 31 
              RELEASE_TAGS rt,
26 
			   PACKAGE_PATCHES pp,
 32 
              PACKAGE_PATCHES pp,
27 
			   PACKAGE_VERSIONS pv
 33 
              PACKAGE_VERSIONS pv,
- 
 
 34 
              WORK_IN_PROGRESS wip
28 
		 WHERE rc.RTAG_ID = rt.RTAG_ID
 35 
        WHERE rc.RTAG_ID    = rt.RTAG_ID
29 
		   AND rt.OFFICIAL != 'Y'
36 
          AND rt.OFFICIAL    IN ('N','R','C')
30 
		   AND pp.PV_ID = rc.PV_ID
 37 
          AND pp.PV_ID        = rc.PV_ID
31 
		   AND pp.PATCH_ID = pv.PV_ID
 38 
          AND pp.PATCH_ID     = pv.PV_ID
32 
		   AND pv.DLOCKED != 'Y'
 39 
          AND pv.DLOCKED     != 'Y'
33 
		   AND pv.IS_OBSOLETE IS NULL
 40 
          AND pv.IS_OBSOLETE IS NULL
34 
		   AND pv.MODIFIER_ID = :USER_ID
 41 
          AND pv.MODIFIER_ID  = :USER_ID
- 
 
 42 
          AND wip.RTAG_ID     = rt.RTAG_ID
- 
 
 43 
          AND wip.PV_ID       = pp.PATCH_ID
35
44
36
45
37 
  	   ) rel,
 46 
       ) rel,
38 
	   PACKAGES pkg,
 47 
       PACKAGES pkg,
39 
	   RELEASE_TAGS rt,
 48 
       RELEASE_TAGS rt,
40 
	   PROJECTS pr
 49 
       PROJECTS pr
41 
 WHERE rel.PKG_ID = pkg.PKG_ID
 50 
 WHERE rel.PKG_ID = pkg.PKG_ID
42 
   AND rel.RTAG_ID = rt.RTAG_ID
 51 
   AND rel.RTAG_ID = rt.RTAG_ID
43 
   AND rt.PROJ_ID = pr.PROJ_ID
52 
   AND rt.PROJ_ID = pr.PROJ_ID
44 
ORDER BY UPPER(LOCATION), UPPER(pkg.PKG_NAME)
53 
ORDER BY UPPER(LOCATION), UPPER(pkg.PKG_NAME)