Issues commented by me in JIRA

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()

if you know the name of the user (lets assume the name is Tom you can do:

issueFunction in commented("by Tom")

you can also filter it by date of the comment like:

issueFunction in commented("after -1d by Tom")

UPDATE: this requires ScriptRunner being installed in JIRA server (as JBert pointed out)

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.)

You could also follow the approach presented by Matt Doar:

Use a participants field from the JIRA Toolkit plugin and query that

http://confluence.atlassian.com/display/JIRA/Advanced+Searching?focusedCommentId=229838922#comment-229838922

It's not a a complete answer but maybe a step in the right direction... Francis

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()

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)

You can try that workaround I am current using this expression on my saved search:

comment ~ "your.username.here"

This in fact catch the comments where I was mentioned, but if you mention yourself probably should works. I have not tried by myself.

My current Jira is a cloud based one, so I can't tell you exactly which version is.

In JIRA v7.3.0, the watcher field works well, if autowatch is enabled:

watcher = currentUser()

How to enable Profile > Preferences > Autowatch : [inhert, disabled, enabled]

Issues that you create or comment on will automatically be watched for future changes.

For filtering issues in which you have been mentioned, try comment ~ currentUser()

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>';

If you're talking only about the current user, there is a personal Activity Stream in your profile

https://xxx.atlassian.net/secure/ViewProfile.jspa

It includes actions other than comments, but does provide an RSS feed which you could filter only comments with:

<category term="comment"/>

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;