Differences

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

--- oss-health-metrics:metrics:pull-requests-open [2017/05/18 00:06]
GeorgLink new template
+++ oss-health-metrics:metrics:pull-requests-open [2017/10/06 20:57] (current)
GeorgLink fixed link
@@ Line 1: / Line 1: @@
 ====== Pull Requests Open ======
-===== 1. Description =====
+Page permanently moved to
-Number of open pull requests
+https://github.com/chaoss/metrics/blob/master/activity-metrics/pull-requests-open.md
-Might be more telling than total pull requests
-===== 2. Use Cases =====
-===== 3. Sample Visualization =====
-===== 4. Sample Implementation =====
-=== GHTorrent ===
-	SELECT count(distinct pull_request_id) as num_still_open, projects.name as project_name, projects.url as url
-	FROM msr14.pull_request_history
-	    join pull_requests on pull_request_history.pull_request_id = pull_requests.id
-	    join projects on pull_requests.base_repo_id = projects.id
-	where pull_request_id not in
-	    (SELECT pull_request_id
-	    FROM msr14.pull_request_history
-	    where action = 'closed')
-	group by projects.id
-===== 5. Known Implementations =====
-===== 6. External References (Literature) =====

Wiki