Differences

This shows you the differences between two versions of the page.

--- oss-health-metrics:metrics:issues-open [2017/04/10 18:49]
abuhman [10. Internet References]
+++ oss-health-metrics:metrics:issues-open [2017/10/06 20:55] (current)
GeorgLink fixed link
@@ Line 1: / Line 1: @@
 ====== Issues Open ======
-===== 1. Acronym =====
-===== 2. Alternate Names =====
+Page permanently moved to
+https://github.com/chaoss/metrics/blob/master/activity-metrics/issues-open.md
-===== 3. Classification =====
-Community Code
-===== 4. Description =====
-Number of open issues
-==== Visualization ====
-==== Interpretation ====
-===== 5. Known Implementations =====
-===== 6. Data Source =====
-GHTorrent
-===== 7. Pseudo Code/Query =====
-=== Number of Open Issues (current)===
-	SELECT count(distinct issue_events.issue_id) as num_open_issues, projects.name as project_name, url as url
-	FROM msr14.issue_events
-		join issues on issues.id = issue_events.issue_id
-		join projects on issues.repo_id = projects.id
-	where issue_events.issue_id not in
-		(SELECT issue_id FROM msr14.issue_events
-		where action = 'closed')
-	group by projects.id
-===== 8. Data Exchange Format =====
-===== 9. References to Academic Literature =====
-===== 10. Internet References =====
-===== 11. Contributors =====
-Authors of the metric page and authors who made significant changes.

Wiki