Jira Issue DB query Statement

# DB선택
use jirsdb;

# REPOTER와 user name 출력,  #출력된 reporter_name의 user에 해당하는 REPORTER값 확인
SELECT ji.REPORTER, MAX(au.lower_user_name) AS reporter_name FROM jiraissue ji  LEFT JOIN app_user au ON ji.REPORTER = au.user_key  GROUP BY ji.REPORTER ORDER BY ji.REPORTER;

# jira issue 생성 수 
SELECT COUNT(*) AS issue_count FROM jiraissue WHERE REPORTER='REPORTER_NAME'; 
ex) SELECT COUNT(*) AS issue_count FROM jiraissue WHERE REPORTER='JIRAUSER10000';

# DB선택
use jirsdb;

# Jira 댓글 수
SELECT COUNT(*) AS comment_count FROM jiraaction ja JOIN jiraissue ji ON ja.issueid = ji.id WHERE ja.author = 'JIRAUSER10000';