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

XMLWordPrintable

    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:
          0 Vote for this issue
          Watchers:
          1 Start watching this issue

            Created:
            Updated: