BugFree background Statistics Bug information, bugfree background bug
The following are the Details table information // statistics of the severity Level BugSELECT severity, count (severity) FROM 'bf _ bugview 'where product_id = 476 group by severity // statistics creator BugSELECT created_by_name, count (created_by_name) as count FROM 'bf _ bugview 'where product_id = 476 group by created_by_name order by count ASC // The statistic Releaser BugSELECT resolved_by_name, count (resolved_by_name) as count FROM 'bf _ bugview' where product_id = 476 group by resolved_by_name order by count ASC // statistics of each version Bugselect bf_add.version version, count (*) from bf_bug_info as B _info join bf_addonbug_476 as bf_add on (bf_add.bug_id = B _info.id) WHERE B _info.product_id = 476 group by version // calculate the newly introduced Bugselect bf_add.version in each round, count (*) from bf_bug_info as B _info join bf_addonbug_476 as bf_add on (bf_add.bug_id = B _info.id) WHERE B _info.product_id = 476 and B _info.newly_bug = 'is 'group BY bf_add.version/ /Calculate the missing Bugselect bf_add.version in each round, count (*) from bf_bug_info as B _info join bf_addonbug_476 as bf_add on (bf_add.bug_id = B _info.id) WHERE B _info.product_id = 476 and B _info.missing_bug = 'is 'group BY bf_add.version // counts the activation of Bugselect bf_add.version in each round, count (*) from bf_bug_info as B _info join region as bf_add on) WHERE B _info.product_id = 476 and B _info.missing_bug = 'is 'G Roup by bf_add.version // collects statistics for each round using the exception Bugselect bf_add.version, count (*) from bf_bug_info as B _info join bf_addonbug_476 as bf_add on (bf_add.bug_id = B _info.id) WHERE B _info.product_id = 476 and B _info.case_bug = 'is 'group BY bf_add.version // Bug type distribution select // The solution for counting each round has been fixed and such a Bugselect bf_add.version is designed, count (*) from bf_bug_info as B _info join bf_addonbug_476 as bf_add on (bf_add.bug_id = B _info.id) WHERE B _ Info. product_id = 476 and (B _info.solution = 'fixed' or B _info.solution = 'by Design ') GROUP By bf_add.version // counts the Bug information of each module (until all module nodes) select module_name, count (module_name) FROM bf_bugview where product_id = 476 group by module_name // calculate which modules of a product select B _pro_m.full_path_name, count (B _pro_m.full_path_name) from bf_product_module B _pro_m join bf_bug_info as B _info on (B _info.productmodule_id = B _pro _ M. id) where B _info.product_id = 476 group by B _pro_m.full_path_name: 3D table information // The Bug information in the statistics module select bf_add.version version, count (bf_add.version) as 'Total', count (bf_add_new.version) as 'new introduction', count (bf_add_miss.version) as 'missed test', count (bf_add_testcase.version) as 'exception Bug with set', count (bf_add_fixed.version) as 'has been repaired or designed so' from bf_bug_info as B _info join bf_addonbug_476 as bf_add on (bf_add.bug_id = B _info.id) left join Stored as bf_add_new on (placement = B _info.id and B _info.newly_bug = 'Yes') left join bf_addonbug_476 as bf_add_miss on (placement = B _info.id and B _info.missing_bug = 'Yes ') left join region as bf_add_testcase on (region = B _info.id and B _info.case_bug = 'Yes') left join bf_addonbug_476 as bf_add_fixed on (region = B _info.id and (B _info.solution = 'fix Ed 'or B _info.solution = 'by Design') WHERE B _info.product_id = 476 GROUP By version select bf_add.version version, count (bf_add.version) as 'count1 ', count (bf_add_new.version) as 'new introduction', count (bf_add_miss.version) as 'undertest', count (bf_add_testcase.version) as 'use exception Bug ', count (bf_add_fixed.version) as' has been fixed or designed so ', count (bf_add_reopen.version) as 'active' from bf_bug_info as B _info join bf_addonbug_476 as bf_add on (Condition = B _info.id) left join region as bf_add_new on (condition = B _info.id and B _info.newly_bug = 'Yes') left join region as bf_add_miss on (condition = B _info.id and B _info.missing_bug = 'Yes ') left join bf_addonbug_476 as bf_add_testcase on (bf_add_testcase.bug_id = B _info.id and B _info.case_bug = 'Yes') left join bf_addonbug_476 as bf_add_fixon (placement = B _ Info. id and (B _info.solution = 'fixed' or B _info.solution = 'by Design ') left join bf_addonbug_476 as bf_add_reopen on (region = B _info.id and B _info.reopen_count! = '0') WHERE B _info.product_id = 476 GROUP BY version global statistics // count the number of Bug tickets submitted BY each product select bp. name, count (bp. name) count from bf_bug_info bf JOIN bf_product bp ON (bp. id = bf. product_id) where bf. created_at BETWEEN 20160101 AND 20161001 group by bp. name order by count DESC // The keyword title matches select bf. id, bf. title, bp. name from bf_bug_info bf join bf_product bp on (bp. id = bf. product_id) WHERE bf. created_at BETWEEN 20160101 AND 20161009 and bf. title like "DHCP %" // select bt Based on the Bug ticket submitted by each person. realname, count (*) count from bf_bug_info bf JOIN bf_test_user bt ON (bf. created_by = bt. id) WHERE bf. created_at BETWEEN 20100101 AND 20161009 group by bt. username order by bt. username DESC // install