JQL Enhancement: Allow Filtering by Comment Date to Accurately Find Recent Mentions

XMLWordPrintable

    • 1

      Currently, to list work items where the current user is mentioned, we use a JQL query like:
      comment ~ currentUser() AND updated >= -7d
      This is intended to return issues where the user was mentioned and the issue was updated in the last 7 days.

      This approach often returns false positives. For example, if a user was mentioned in a comment a year ago, but the issue was updated for any other reason (e.g., a field change) in the past week, it will still appear in the results. This makes it difficult to accurately find issues where the user was actually mentioned in the last 7 days.

      Suggestion:
      Introduce a JQL function or field that allows filtering based on the date of the comment itself. For example, a function like commentedOn >= -7d or the ability to specify a date range for comments in the JQL.

      Example:
      A possible JQL query could be:
      comment ~ currentUser() AND commentDate >= -7d
      This would return only issues where the user was mentioned in a comment in the last 7 days, regardless of other updates to the issue.

              Assignee:
              Unassigned
              Reporter:
              Denzil Dsouza
              Votes:
              2 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated: