About updatedBy() in JQL

[Yuta Igarashi]

I have a question about Jira's JQL updatedBy() function in Confluence.

This function searches for issues where a particular user has created, deleted, or edited comments, etc., and outputs the target tickets by day.

How can I output tickets by hours or minutes? For example, I want to output tickets where smith created & edited comments since 7:30 yesterday.

If there is a way to output tickets for the creating or editing of a particular user's comments by the hour or minute, could you please let me know?

[Ste Wright]

Hi @Yuta Igarashi 

Natively, there isn't a function to search for commenters and dates in this manner.

You could...

• Create 2 custom fields - a Date Timer Picker field and a User Picker field
• Populate them using Automation each time a comment is created/edited
• Search using these fields (date/time picker will go down to minute)

This would give you last commenter, and the last comment date. It's not quite the same, but might get you some of the way there.

---

Alternatively, I'd check out what the JQL Apps can offer - such as...

• JQL Search Extensions
• Enhanced Search
• ...or another App from the Marketplace

Ste