User Tools

Site Tools


oss-health-metrics:metrics:issues-open

This is an old revision of the document!


Issues Open

1. Acronym

2. Alternate Names

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

Links to websites that add value to the understanding of the metric.

11. Contributors

Authors of the metric page and authors who made significant changes.

oss-health-metrics/metrics/issues-open.1491850192.txt.gz · Last modified: 2017/04/10 18:49 by abuhman