About updatedBy() in JQL

Yuta Igarashi
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 5, 2023

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?



1 answer

0 votes
Ste Wright
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 25, 2023

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...


Suggest an answer

Log in or Sign up to answer
AUG Leaders

Atlassian Community Events