Subversion Repositories DevTools

Rev

Details | Last modification | View Log | RSS feed

Rev Author Line No. Line
64 jtweddle 1 
SELECT  ttypes.test_type_id, ttypes.test_type_name,
2 
		ut.TEST_ID,
3 
		ut.PV_ID,
4 
		ut.TEST_SUMMARY,
5 
		ut.COMPLETION_DATE,
6 
		tusr.full_name AS TESTER,
7 
		tusr.user_email AS TESTER_EMAIL,
8 
		ut.RESULTS_URL,
9 
		ut.RESULTS_ATTACHMENT_NAME
10 
  FROM UNIT_TESTS ut,
11 
  	   (
12 
	    SELECT tt.*
13 
		  FROM TEST_TYPES tt
14 
		 WHERE NOT tt.DISPLAY_ORDER IS NULL
15 
	   ) ttypes,
16 
	   USERS tusr
17 
 WHERE /* ut.TEST_TYPES_FK (+)= ttypes.test_type_id -- REPLACED WITH NEXT LINE TEMPORARY  */
18 
   ut.TEST_TYPES_FK = ttypes.test_type_id
19 
   AND ut.pv_id (+) = :PV_ID
20 
   AND ut.COMPLETED_BY = tusr.user_id (+)
21 
ORDER BY ut.COMPLETION_DATE DESC
22