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 
/* Work In Progress by User */
 2 
-- WorkInProgressByUser.sql
- 
 
 3 
-- Keep in step with 'UserWip.sql'
- 
 
 4 
--
- 
 
 5 
--   Used by index.asp to list Releases and Package Versions
- 
 
 6 
--   that the user is working on
- 
 
 7 
-- =====================================================
2 
SELECT usr.USER_ID,
 8 
SELECT usr.USER_ID,
3 
	   usr.FULL_NAME,
 9 
	   usr.FULL_NAME,
4 
	   usr.USER_EMAIL,
 10 
	   usr.USER_EMAIL,
5 
	   COUNT(usr.USER_ID) AS COUNTER
 11 
	   COUNT(usr.USER_ID) AS COUNTER
6 
  FROM (
 12 
  FROM (
Line 9... Line 15...
9 
        SELECT wip.PV_ID, rt.RTAG_ID, pv.MODIFIER_ID
 15 
        SELECT wip.PV_ID, rt.RTAG_ID, pv.MODIFIER_ID
10 
		  FROM WORK_IN_PROGRESS wip,
 16 
		  FROM WORK_IN_PROGRESS wip,
11 
		  	   RELEASE_TAGS rt,
 17 
		  	   RELEASE_TAGS rt,
12 
			   PACKAGE_VERSIONS pv
 18 
			   PACKAGE_VERSIONS pv
13 
		 WHERE wip.RTAG_ID = rt.RTAG_ID
 19 
		 WHERE wip.RTAG_ID = rt.RTAG_ID
14 
		   AND rt.OFFICIAL != 'Y'
 20 
		   AND rt.OFFICIAL In ('N','R','C')
15 
		   AND wip.PV_ID = pv.PV_ID
 21 
		   AND wip.PV_ID = pv.PV_ID
16 
		   AND pv.DLOCKED != 'Y'
 22 
		   AND pv.DLOCKED != 'Y'
- 
 
 23 
       AND pv.MODIFIER_ID = :USER_ID
17
24
18 
		UNION
25 
		UNION
19
26
20 
		/* Get WIP Patches */
 27 
		/* Get WIP Patches */
21 
        SELECT pp.PATCH_ID AS PV_ID, rt.RTAG_ID, pv.MODIFIER_ID
 28 
        SELECT pp.PATCH_ID AS PV_ID, rt.RTAG_ID, pv.MODIFIER_ID
22 
		  FROM RELEASE_CONTENT rc,
 29 
		  FROM RELEASE_CONTENT rc,
23 
		  	   RELEASE_TAGS rt,
 30 
		  	   RELEASE_TAGS rt,
24 
			   PACKAGE_PATCHES pp,
 31 
			   PACKAGE_PATCHES pp,
25 
			   PACKAGE_VERSIONS pv
 32 
			   PACKAGE_VERSIONS pv,
- 
 
 33 
         WORK_IN_PROGRESS wip
26 
		 WHERE rc.RTAG_ID = rt.RTAG_ID
 34 
		 WHERE rc.RTAG_ID = rt.RTAG_ID
27 
		   AND rt.OFFICIAL != 'Y'
35 
		   AND rt.OFFICIAL In ('N','R','C')
28 
		   AND pp.PV_ID = rc.PV_ID
 36 
		   AND pp.PV_ID = rc.PV_ID
29 
		   AND pp.PATCH_ID = pv.PV_ID
 37 
		   AND pp.PATCH_ID = pv.PV_ID
30 
		   AND pv.DLOCKED != 'Y'
 38 
		   AND pv.DLOCKED != 'Y'
31 
		   AND pv.IS_OBSOLETE IS NULL
 39 
		   AND pv.IS_OBSOLETE IS NULL
- 
 
 40 
       AND pv.MODIFIER_ID = :USER_ID
32
41 
		   AND wip.RTAG_ID = rt.RTAG_ID
- 
 
 42 
       AND wip.PV_ID = pp.PATCH_ID
33
43
34 
  	   ) rel,
 44 
  	   ) rel,
35 
  	   USERS usr
 45 
  	   USERS usr
36 
 WHERE rel.MODIFIER_ID = usr.USER_ID
46 
 WHERE rel.MODIFIER_ID = usr.USER_ID
37 
 AND usr.IS_DISABLED IS NULL
- 
 
38 
 AND usr.user_id = :USER_ID
 - 
 
39 
 GROUP BY  usr.USER_ID, usr.FULL_NAME, usr.USER_EMAIL
 47 
 GROUP BY  usr.USER_ID, usr.FULL_NAME, usr.USER_EMAIL
40 
 ORDER BY UPPER(usr.FULL_NAME)
 - 
 
- 
 
 48