oss-health-metrics:metrics:reopened-issues
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
oss-health-metrics:metrics:reopened-issues [2017/05/18 00:04] GeorgLink [4. Sample Implementation] |
oss-health-metrics:metrics:reopened-issues [2017/10/06 20:58] (current) GeorgLink fixed link |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Reopened Issues ====== | ====== Reopened Issues ====== | ||
| - | ===== 1. Description ===== | + | Page permanently moved to |
| - | Rate of issues closed but discussion continues or issues that were closed and re-opened | + | https://github.com/chaoss/metrics/blob/master/activity-metrics/reopened-issues.md |
| - | + | ||
| - | ===== 2. Use Cases ===== | + | |
| - | + | ||
| - | ===== 3. Sample Visualization ===== | + | |
| - | + | ||
| - | ===== 4. Sample Implementation ===== | + | |
| - | === GHTorrent: Reopened issues === | + | |
| - | + | ||
| - | == Total closed issues by project == | + | |
| - | + | ||
| - | select count(distinct issues.id) as total_issues, projects.name as project_name, projects.url as project_url | + | |
| - | from | + | |
| - | issues join projects | + | |
| - | on issues.repo_id = projects.id | + | |
| - | join issue_events | + | |
| - | on issue_events.issue_id = issues.id | + | |
| - | where issue_events.action = 'closed' | + | |
| - | group by projects.id | + | |
| - | + | ||
| - | == Reopened issues: == | + | |
| - | + | ||
| - | select count(distinct issues.id) as total_reopened_issues, projects.name as project_name | + | |
| - | from | + | |
| - | issues join projects | + | |
| - | on issues.repo_id = projects.id | + | |
| - | join issue_events | + | |
| - | on issue_events.issue_id = issues.id | + | |
| - | where issue_events.action = 'reopened' | + | |
| - | group by projects.id | + | |
| - | + | ||
| - | ==issues with comments after issue is closed:== | + | |
| - | + | ||
| - | select count(distinct comment_issue_id) as num_issues_with_comments_after_closed, comment_project_name as project_name | + | |
| - | from | + | |
| - | (select issues.id as comment_issue_id, projects.id as comment_project_id, issue_comments.created_at as comment_date, projects.name as comment_project_name | + | |
| - | from issue_comments | + | |
| - | join issues on issue_comments.issue_id = issues.id | + | |
| - | join projects on projects.id = issues.repo_id) as comment_issues | + | |
| - | join | + | |
| - | (select issues.id as closed_issue_id, projects.id as closed_project_id, issue_events.created_at as closed_date | + | |
| - | from | + | |
| - | issues join projects | + | |
| - | on issues.repo_id = projects.id | + | |
| - | join issue_events | + | |
| - | on issue_events.issue_id = issues.id | + | |
| - | where issue_events.action = 'closed') as closed_issues | + | |
| - | on closed_issue_id = comment_issue_id AND comment_project_id = closed_project_id AND comment_date > closed_date | + | |
| - | group by comment_project_id | + | |
| - | + | ||
| - | == Issues with no comments after issue closed: == | + | |
| - | + | ||
| - | select count(distinct issues.id) as num_issues_no_comments_after_close, projects.name as project_name | + | |
| - | from | + | |
| - | issues join projects | + | |
| - | on issues.repo_id = projects.id | + | |
| - | join issue_events | + | |
| - | on issue_events.issue_id = issues.id | + | |
| - | where issue_events.action = 'closed' AND (issues.id, projects.id) | + | |
| - | not in( | + | |
| - | select comment_issue_id, comment_project_id | + | |
| - | from | + | |
| - | (select issues.id as comment_issue_id, projects.id as comment_project_id, issue_comments.created_at as comment_date, projects.name as comment_project_name | + | |
| - | from issue_comments | + | |
| - | join issues on issue_comments.issue_id = issues.id | + | |
| - | join projects on projects.id = issues.repo_id) as comment_issues | + | |
| - | join | + | |
| - | (select issues.id as closed_issue_id, projects.id as closed_project_id, issue_events.created_at as closed_date | + | |
| - | from | + | |
| - | issues join projects | + | |
| - | on issues.repo_id = projects.id | + | |
| - | join issue_events | + | |
| - | on issue_events.issue_id = issues.id | + | |
| - | where issue_events.action = 'closed') as closed_issues | + | |
| - | on closed_issue_id = comment_issue_id AND comment_project_id = closed_project_id AND comment_date > closed_date) | + | |
| - | group by projects.id | + | |
| - | + | ||
| - | + | ||
| - | ===== 5. Known Implementations ===== | + | |
| - | + | ||
| - | ===== 6. External References (Literature) ===== | + | |
oss-health-metrics/metrics/reopened-issues.1495065869.txt.gz · Last modified: 2017/05/18 00:04 by GeorgLink
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
