Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
119 ghuddy 1 
/* Work In Progress by User */
2 
SELECT usr.USER_ID,
3 
	   usr.FULL_NAME,
4 
	   usr.USER_EMAIL,
5 
	   COUNT(usr.USER_ID) AS COUNTER
6 
  FROM (
7 
 
8 
  		/* Get WIP Packages */
9 
        SELECT wip.PV_ID, rt.RTAG_ID, pv.MODIFIER_ID
10 
		  FROM WORK_IN_PROGRESS wip,
11 
		  	   RELEASE_TAGS rt,
12 
			   PACKAGE_VERSIONS pv
13 
		 WHERE wip.RTAG_ID = rt.RTAG_ID
14 
		   AND rt.OFFICIAL != 'Y'
15 
		   AND wip.PV_ID = pv.PV_ID
16 
		   AND pv.DLOCKED != 'Y'
17 
 
18 
		UNION
19 
 
20 
		/* Get WIP Patches */
21 
        SELECT pp.PATCH_ID AS PV_ID, rt.RTAG_ID, pv.MODIFIER_ID
22 
		  FROM RELEASE_CONTENT rc,
23 
		  	   RELEASE_TAGS rt,
24 
			   PACKAGE_PATCHES pp,
25 
			   PACKAGE_VERSIONS pv
26 
		 WHERE rc.RTAG_ID = rt.RTAG_ID
27 
		   AND rt.OFFICIAL != 'Y'
28 
		   AND pp.PV_ID = rc.PV_ID
29 
		   AND pp.PATCH_ID = pv.PV_ID
30 
		   AND pv.DLOCKED != 'Y'
31 
		   AND pv.IS_OBSOLETE IS NULL
32 
 
33 
 
34 
  	   ) rel,
35 
  	   USERS usr
36 
 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
40 
 ORDER BY UPPER(usr.FULL_NAME)