| Line 93... |
Line 93... |
| 93 |
-- filter on project
|
93 |
-- filter on project
|
| 94 |
AND si.project IN ('Seattle','VasTraffik 1','Vas Traffik 2/3','Stagecoach Bus Hops','Stagecoach South West','TRACS')
|
94 |
AND si.project IN ('Seattle','VasTraffik 1','Vas Traffik 2/3','Stagecoach Bus Hops','Stagecoach South West','TRACS')
|
| 95 |
-- filter on defect type
|
95 |
-- filter on defect type
|
| 96 |
AND si.issue_type IN ('Defect','FQT defect','Integration defect','Test Failure','Documentation')
|
96 |
AND si.issue_type IN ('Defect','FQT defect','Integration defect','Test Failure','Documentation')
|
| 97 |
-- filter on submitter
|
97 |
-- filter on submitter
|
| 98 |
AND (
|
- |
|
| 99 |
(us.login_name IN ('aphoon','amatveev','aserrain','clee','ekilic','lguntur',
|
98 |
AND us.login_name IN ('aphoon','amatveev','aserrain','clee','ekilic','fpatel','lguntur',
|
| 100 |
'ggrieve','hbatna','idzukleski','jgodfrey','jkoh','kmuruges','knguyen',
|
99 |
'ggrieve','hbatna','idzukleski','jgodfrey','jkoh','kmuruges','knguyen',
|
| 101 |
'lmiao','mthangav','nkerr','ozaidenv','rthumma','rohearn','sip','kmaesen2',
|
100 |
'lmiao','mthangav','nkerr','ozaidenv','rthumma','rohearn','sip','kmaesen2',
|
| 102 |
'slibao','stan','tkumar','wloo','ywehalle','sradhakr','bboey','silyas',
|
101 |
'slibao','stan','tkumar','wloo','ywehalle','sradhakr','bboey','silyas',
|
| 103 |
'wwong','mchua','dmonahan','awehalle'))
|
102 |
'wwong','mchua','dmonahan','awehalle')
|
| 104 |
OR
|
- |
|
| 105 |
(us.login_name IN ('fpatel') AND (DATEADD(Hour,-DATEDIFF(Hour, GETDATE(), GETUTCDATE()), si.close_date) < '20120130'))
|
- |
|
| 106 |
)
|
- |
|
| 107 |
|
103 |
|
| 108 |
--AND us.fullname IN ('Andrew Phoon','Andrey Matveev','Angelo Serraino','Cherry Lee','Edis Kilic','Falguni Patel','Lakshmi Guntur',
|
104 |
--AND us.fullname IN ('Andrew Phoon','Andrey Matveev','Angelo Serraino','Cherry Lee','Edis Kilic','Falguni Patel','Lakshmi Guntur',
|
| 109 |
-- 'Graeme Grieve','Hari Batna','Igor Dzukleski','Jason Godfrey','Jonathan Koh','Karthikeyan Murugesan','Ken Nguyen',
|
105 |
-- 'Graeme Grieve','Hari Batna','Igor Dzukleski','Jason Godfrey','Jonathan Koh','Karthikeyan Murugesan','Ken Nguyen',
|
| 110 |
-- 'Ling Miao','Malarvizhi Thangavel','Nicolette Kerr','Ory Zaidenvorm','Rakesh Thumma','Roger O''Hearn','Sinmei Ip','Kelly Maesen',
|
106 |
-- 'Ling Miao','Malarvizhi Thangavel','Nicolette Kerr','Ory Zaidenvorm','Rakesh Thumma','Roger O''Hearn','Sinmei Ip','Kelly Maesen',
|
| 111 |
-- 'Sonia Libao','Stephen Tan','Tarun Kumar','William Wah Kim Loo','Yohan Wehalle','Sree Radhakrishnan','Brian Boey','Sasithorn Ilyas','Wing Wong')
|
107 |
-- 'Sonia Libao','Stephen Tan','Tarun Kumar','William Wah Kim Loo','Yohan Wehalle','Sree Radhakrishnan','Brian Boey','Sasithorn Ilyas','Wing Wong')
|
| 112 |
) df
|
108 |
) df
|
| 113 |
where
|
109 |
where
|