Issues commented by me in JIRA

Question

As per JIRA documentation http://www.atlassian.com/software/jira/docs/latest

The following filter will show the issues opned by me (Current User).

reporter = currentUser()

Is there a filer that will show issues commented by me? something like the following does not work...

comment by = currentUser()

Answer 1

I had the same problem and

issueFunction in commented("by username") 

worked for me

The following query identifies tickets in which current (or some other particular) user was mentioned in comments:

comment ~ currentUser()

Answer 2

The new scriptrunner can do lots of things e.g. find issues with comments issueFunction in hasComments(), find issues with comments that are not older than 7 days issueFunction in commented("after -7d") and also issue comments from users or groups.

Details can be found here: https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-commented(commentquery)

Answer 3

This (to my knowledge) cannot be completed using JQL, even with a plugin. If you have DB access, the query is simple:

SELECT pkey, summary FROM jiraissue, jiraaction WHERE jiraissue.id = jiraaction.issueid AND author = '<insert_jira_username>';

Answer 4

This is the query to know the issues I am involved in:

SELECT a.pkey, a.summary FROM jiraissue AS a left join jiraaction AS b on a.id = b.issueid 
where b.author = 'jira_username' OR a.REPORTER = 'jira_username' OR a.ASSIGNEE = 'jira_username' 
group by a.pkey order by a.CREATED

This is the query to know all issues raised in the last 24 hours.

select REPORTER, SUMMARY from jiraissue 
WHERE CREATED > DATE_SUB(CURDATE(), INTERVAL 1 DAY)  order by CREATED DESC; 

Answer 5

You can use the Activity Stream gadget with a filter configured by username and activity type. Note that this requires a case-sensitive username, not the friendly Display Name.

Activity Stream gadget configuration:

Filtered Activity Stream display:

(I posted a variation of this answer elsewhere but have improved my filter since then and the new filter is more salient to this question anyhow.)