How do I search for comments by a specific user?

[Nariman Riahi]

In cloud JIRA I like to see what tickets were updated by "joe" in last 24 hours. 

You would think that this is something that is available out of the box, or am I missing something?

thanks

[Conrad]

In case this is still something that people need help with. The way I was able to get issues by commentators was by using the issueFunction:

...AND (issueFunction in commented("by [user]") OR issueFunction in commented("by [user]") OR issueFunction in commented("by [user]"))...

[Iana]

@Conrad is IssueFunction available in Server? 
I tried using it in a JQL search and I got an error saying it doesn't exist. 

Am I doing something wrong?

[mikutech]

Nope, issueFunction is part of the Scriptrunner extension. It does not exist in default Jira. I'm looking around myself for a non-extension way to do this also.

[Iana]

Hi @mikutech

That makes sense. If you happen to find a way, please don't hesitate to share

[Mike May]

Still hoping for this functionality out of the box. 

[Apogee Research]

I'm not sure this will be possible with the cloud implementation, I only have an on-prem to work with.

If you can get access to the underlying database:

select issueid,actionbody from jiraaction where author = 'insert username here';

If you need to verify the username to query for:

select author from jiraaction;

to get a list

Yes, I think it's non-optimal to not be able to do this from JQL. It's impossible to delete a user that has comments on issues. There's no way to change the ownership of the comment in the UI, even if you can find them. The bulk edit function won't touch the comments. So the only solution is to modify the db directly using variants on the above queries or find them all and delete the comments in the UI.

[Melissa_Liotta]

Hello,

I see that in 2017 you could not do a search for comments added by a specific user, but has this changed or is it still not available out of the box?

Thank you, Melissa

[Jobin Kuruvilla [Adaptavist]]

If you want to find issues where a comment was added by a user, you need a plugin like JQL Tricks. It cannot be done by the default search functionality.

[Nariman Riahi]

thanks.

Sad that Atlassian does not support such basic use case. For us who use Cloud instance and do not even have the option to use add-ons. 

[Gregory Van Den Ham]

try a JQL Issue search something like:   

status changed by "Username" and updated> startOfDay("-1")

In this case startOfday would be today and this is looking at the users updates from yesterday (the -1).

If you're not sure of the person's username, find it in their profile or if you have admin access, look at their user info through the admin users screens.

[Nariman Riahi]

I am looking for any update. Not just status change. In particular I am looking for users who put a comment in the ticket but do not change anything about the ticket so I hard time to find out through Status or Assignee change. 

How do I find out tickets were a comment was added in the last 24 hours?