Subversion Repositories DevTools

Rev

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

Rev 2195 Rev 2197
Line 48... Line 48...
48 
      -- filter on submitter
 48 
      -- filter on submitter
49 
      AND si.reporter IN ('aphoon','amatveev','aserrain','clee','ekilic','fpatel','lguntur',
 49 
      AND si.reporter IN ('aphoon','amatveev','aserrain','clee','ekilic','fpatel','lguntur',
50 
                          'ggrieve','hbatna','idzukleski','jgodfrey','jkoh','kmuruges','knguyen',
 50 
                          'ggrieve','hbatna','idzukleski','jgodfrey','jkoh','kmuruges','knguyen',
51 
                          'lmiao','mthangav','nkerr','ozaidenv','rthumma','rohearn','sip','kmaesen2',
 51 
                          'lmiao','mthangav','nkerr','ozaidenv','rthumma','rohearn','sip','kmaesen2',
52 
                          'slibao','stan','tkumar','wloo','ywehalle','sradhakr','bboey','silyas',
 52 
                          'slibao','stan','tkumar','wloo','ywehalle','sradhakr','bboey','silyas',
53 
                          'wwong','mchua','dmonahan')
 53 
                          'wwong','mchua','dmonahan','awehalle')
54 
  UNION
54 
  UNION
55 
  -- get closed defects
 55 
  -- get closed defects
56 
  SELECT
56 
  SELECT
57 
       si.id as issue_id,
 57 
       si.id as issue_id,
58 
       DATEADD(mm,(YEAR(si.updated)-1900)* 12 + MONTH(si.updated) - 1, 0)AS defect_month, -- truncate to year,month
 58 
       DATEADD(mm,(YEAR(si.updated)-1900)* 12 + MONTH(si.updated) - 1, 0)AS defect_month, -- truncate to year,month
Line 88... Line 88...
88 
      -- filter on submitter
 88 
      -- filter on submitter
89 
      AND si.reporter IN ('aphoon','amatveev','aserrain','clee','ekilic','fpatel','lguntur',
 89 
      AND si.reporter IN ('aphoon','amatveev','aserrain','clee','ekilic','fpatel','lguntur',
90 
                          'ggrieve','hbatna','idzukleski','jgodfrey','jkoh','kmuruges','knguyen',
 90 
                          'ggrieve','hbatna','idzukleski','jgodfrey','jkoh','kmuruges','knguyen',
91 
                          'lmiao','mthangav','nkerr','ozaidenv','rthumma','rohearn','sip','kmaesen2',
 91 
                          'lmiao','mthangav','nkerr','ozaidenv','rthumma','rohearn','sip','kmaesen2',
92 
                          'slibao','stan','tkumar','wloo','ywehalle','sradhakr','bboey','silyas',
 92 
                          'slibao','stan','tkumar','wloo','ywehalle','sradhakr','bboey','silyas',
93 
                          'wwong','mchua','dmonahan')
 93 
                          'wwong','mchua','dmonahan','awehalle')
94 
   ) df
 94 
   ) df
95 
   where
 95 
   where
96 
    df.defect_datetime >= @start_date AND df.defect_datetime < @end_date
 96 
    df.defect_datetime >= @start_date AND df.defect_datetime < @end_date
97 
GROUP BY df.defect_month,df.project;
 97 
GROUP BY df.defect_month,df.project;
98 

            98