Accessing Comment ID in Custom Email Condition via ScriptRunner

[Chris Knight]

I started using Script Runner (specifically Send a custom email) to work around the poor email notifications in JIRA Service Desk. So far it has worked well. The only struggle I have is with notifying users when comments are added. In Service Desk, there are internal and external comments. I want to be able to send a custom email to the reporter only when an external comment is added and include the text of that comment.

I've struggled with this a bit, but here's what I've found:

1. Service Desk comment visibility is available via the API: https://answers.atlassian.com/questions/12159156

2. I can query the API for a particular comment ID and get the JSON property

   https://jira/rest/api/2/comment/12171/properties/sd.public.comment/

   returns

   {"key":"sd.public.comment","value":{"internal":true}}

3. In the Script Runner console, I can get a true/false value on whether a comment is internal or not:

   def curl = "/usr/bin/curl -u admin:admin https://jira/rest/api/2/comment/12171/properties/sd.public.comment/"
   def result = curl.execute().text
   output = result.contains("true")

I can use the code above in a condition and it evaluates correctly, but the comment ID is hard coded. I tried this:

import com.atlassian.jira.ComponentManager
import com.atlassian.jira.issue.comments.CommentManager
def id = ComponentManager.getCommentManager().getComments(issue).last().id

to get the comment ID, but I keep getting an error:

No signature of method: static com.atlassian.jira.ComponentManager.getCommentManager() is applicable for argument types: () values: [] Possible solutions: getCommentManager(), getConstantsManager(), getProjectManager(), getVoteManager()

How can I get the comment ID in the "Condition" field of Send a custom email?

[Alejo Villarrubia [Adaptavist] · Accepted solution]

Can you try with this?

import com.atlassian.jira.component.ComponentAccessor

def id = ComponentAccessor.getCommentManager().getComments(issue).last().id

[Chris Knight]

Thanks for the quick reply! Unfortunately, I get this error: No such property: ComponentAccessor for class: Script32

[Alejo Villarrubia [Adaptavist]]

Sorry I didn't add the import. I've edited my answer.

[Alejo Villarrubia [Adaptavist]]

Thanks for accepting. Can I ask you to confirm you are testing the script against jira 7 eap?

[Chris Knight]

I'm testing it against JIRA 6.3.8.

[JamieA]

I really advise you not to use this approach... although kudos for finding it. The problem is that for anyone that uses SSL they are likely to have certificate problems, plus you are hard-coding credentials, and it's not easy to use the credentials of some other user. A better approach (imho) is here: https://answers.atlassian.com/questions/14212548/answers/14212563