User Tools

Site Tools


oss-health-metrics:metrics:issues-open

Differences

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

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
oss-health-metrics:metrics:issues-open [2017/05/18 00:15]
GeorgLink add link back to list
oss-health-metrics:metrics:issues-open [2017/10/06 20:55] (current)
GeorgLink fixed link
Line 1: Line 1:
-__**[[oss-health-metrics:​metrics|<<​ Back to List of Activity Metrics]]**__ 
 ====== Issues Open ====== ====== Issues Open ======
  
-===== 1. Description ===== +Page permanently moved to  
-Number of open issues +https://github.com/​chaoss/​metrics/​blob/​master/​activity-metrics/​issues-open.md
- +
-===== 2. Use Cases ===== +
- +
-===== 3. Sample Visualization ===== +
- +
-===== 4. Sample Implementation ===== +
-===GHTorrentNumber 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 +
- +
- +
-===== 5. Known Implementations ===== +
- +
-===== 6. External References (Literature) ===== +
oss-health-metrics/metrics/issues-open.1495066513.txt.gz · Last modified: 2017/05/18 00:15 by GeorgLink