Updated on specific date

[Caroline Gigoi]

Hi,

I would like to be able to build a search script based on the date at which a ticket is updated by someone. So I'm looking for a way to query the comment field and look for the date at which a user has written a comment.

Does somebody know how to write this please ? 

[Mark Segall]

Hi @Caroline Gigoi and welcome to the community!  

You won't be able to get this with JQL alone.  However, a common approach that I've seen taken for this is to use custom fields and automation:

• Date Field (Last Commented)
• Paragraph Field (Last Comment) ** Optional

Automation Rule

• TRIGGER: Issue Commented
• ACTION: Edit Issue
  • Last Commented

    • {{comment.created}}

  • Last Comment

    • By {{comment.author.displayName}}
      {{comment.body}}

Then you can execute JQL like any other date field:

"Last Commented" >= startOfWeek()

[Caroline Gigoi]

Many thanks @Mark Segall