Subversion Repositories DevTools

Rev

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

Rev 2205 Rev 2207
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