How can I query issues in which I commented?

[philippos]

I want to query JIRA issues in which:

• I commented after 1-MAR 

I use the following JQL query which is not what I want.

project = MyProject AND Participants = MyUser AND updated >= "2015/03/01" 

My query querries:

• Issues updated after 1-MAR 
• In the list of participants I was included

This is not correct since I may have commented 1 year ago and the issue was updated on 10-MAR.

What I need is a query where MY comment was between 1-MAR and 30-MAR.

Thanks

P.S. Note that I cannot install plug-ins, I need a JQL query.

[Silviu Burcea · Accepted solution]

I just had another look in the JQL documentation and this is not possible without using a plugin.

[Udo Brand]

Correct, without a plugin this is not possible

[SanaS]

You need scriptrunner for this query unfortunately: https://jamieechlin.atlassian.net/wiki/display/GRV/Scripted+JQL+Functions#ScriptedJQLFunctions-commented(commentquery)

[Silviu Burcea]

P.S. Note that I cannot install plug-ins, I need a JQL query.

[John Bayne]

Agreed.

The participants field created with the JIRA Toolkit Plugin is a help with this while not being a full solution.

[Silviu Burcea]

P.S. Note that I cannot install plug-ins, I need a JQL query.

[philippos]

Actually I can use the query you proposed! issueFunction is an available in to our system. Many thanks