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;