How do I search for comments by a specific user?

[Lisa Robbins]

This question is in reference to Atlassian Documentation: How to find all the comments related to one user in the database

When I use JQL to find comments created by a certain user such as:

SELECT ji.pkey, ja.actionbody

FROM jiraaction ja, jiraissue ji

WHERE ja.issueid = ji.id

AND ja.actiontype = 'comment'

AND ja.author = 'Robbins1, Lisa'; I get the following error:

Expecting Operator but got 'ji.pkey'  am I typing the JQL in the wrong place?

[Michael Partyka · Accepted solution]

Hi Lisa,

If you have Script Runner plugin (older version for free)

use this jql

project = TEST and issueFunction in commented(' by lisa')

It will all issues which certain user commented