Is there a way to capture the first comment date and time details for external usage.

Sagar B R

Description : When ever the bug ticket gets created, we wanted to check average response time (First comment) for external usage. Can someone help with the JQL query or any other source to get this data for the external use.

Thank you 

Mark Segall

Hi @Sagar B R and welcome to the community!

This is not something you can get natively from JQL.  However, you could use automation to capture the first comment timestamp in another field and perform JQL against that field.  For example:

• TRIGGER: Issue Commented
• CONDITION (Issue Fields Condition):
  We'll verify that your field hasn't already been populated
  • YOURFIELD
    IS NOT EMPTY
• ACTION: Edit Issue (YOURFIELD)

  • {{comment.updated}}