jql query that returns all issues where a particular user made (any) changes within a certain period

[Franziska Buch]

I need to find a ticket where important information was added to the issue (probably comment section) within a certain time period. So far I've tried queries including the blocks "issue in issueHistory()" and "Date1" BEFORE "Date2"". What I'm struggling with is the part that defines that any changes were made by person xyz. Any ideas or alterantive approaches?

[Yuliia_Borivets__SaaSJet_]

Hi @Franziska Buch 

I'm not sure if it's possible with JQL, so I can suggest two alternative solutions that can work for your case.

1. Activity Stream Gadget on Jira dashboard. You can select the person who made changes (Account ID), dates, and some activities (e.g., comments added). How to configure Activity Stream Gadget for Jira

2. Issue History for Jira app. It offers more flexible filters and a customizable table view.  You can add any standard or custom field to track its activity in a separate column.

*The app is developed by my team. 

[Lars Barthel]

Hi @Franziska Buch 

you could try something like:

issuekey IN updatedBy("username") AND assignee = username AND updated >= startOfDay("-7") ORDER BY updatedDate DESC

to find updated issues from the past week.

If you need a certain period you could go for:

issuekey IN updatedBy("username") AND assignee = username AND updated >= 2023-01-01 AND updated <= 2023-12-31 ORDER BY updatedDate DESC

Best,

Lars