JQL Query to get all ticket on which I added a comment

[Fabrice_FOTSO_ext]

Hello,

I urgently need a JQL query that will allow me to get all tickets on which I added a comment. 

I am using Jira-cloud

thanks

[Trudy Claspill]

Use this filter:

commentedBy=currentUser()

[Benjamin Lellouche]

Hi @Fabrice_FOTSO_ext 

Not possible on Jira Cloud

Only with scriptrunner through: commentedBy = currentuser()

[Trudy Claspill]

Thank you for pointing that out @Benjamin Lellouche 

I do have Adaptavist Scriptrunner. I did not double check that the commentedBy function was native vs. Scriptrunner.

My apologies for leading you astray @Fabrice_FOTSO_ext 

[Fabrice_FOTSO_ext]

Hello Guys,

thanks alot for your quick response.

I've got ScriptRunner, but for some reasons I still can't get it to work, 

the filter commentedBy=currentUser() wouldnt still work

[Trudy Claspill]

Exactly how did it "not work"? Did you get an error message? Were the results not what you expected?

To run queries that have ScriptRunner functions you have to run them from the ScriptRunner Enhanced Search interface which you can find under the Apps menu.

[Fabrice_FOTSO_ext]

Hello, 

sorry for the late reply

it wasnt working because all tickets of all projects needed to be indexed first,

I used a plugin to create the index, it took about 15 hours since there are about 20K tickets in total, but after that everything worked fine, 

thanks for your help all and wish you a very happy new year