Skip to content

Instantly share code, notes, and snippets.

@mrw

mrw/query.sql

Created January 28, 2015 21:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mrw/8176eec50cb321d152fe to your computer and use it in GitHub Desktop.
Save mrw/8176eec50cb321d152fe to your computer and use it in GitHub Desktop.
Download ZIP
JIRA comments by user
Raw
query.sql
SELECT JA.ID, author, JA.created, summary, pname, CONCAT(P.pkey, "-", JI.issuenum), JA.actionbody
FROM jiraaction JA
JOIN jiraissue JI ON JA.issueid = JI.id
JOIN project P ON JI.project = P.id
JOIN app_user U ON U.user_key = JA.author
WHERE JA.actiontype = 'comment'
AND U.lower_user_name = 'xxx'
ORDER BY created DESC;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment