How can I create a JQL filter to get jiras I've created or worked on during specific time period

[pvala_micron_com]

Hi there,

I would like to run a filter for specific time period(between two dates). 

For example, I want to filter out JIRAs that I've created or updated between the dates 1/1/2025 to 31/1/2025. 

I am not sure JQL can support this.

Any suggestions for this please?

Thanks.

[Brita Moorus · Accepted solution]

Hi, @pvala_micron_com! 👋

You can definitely do that with JQL! Here’s how to filter issues you created or updated between two specific dates:

(created >= "2025-01-01" AND created <= "2025-01-31")
OR
(updated >= "2025-01-01" AND updated <= "2025-01-31")
AND
reporter = currentUser()

If you also want to include issues you’ve commented on or changed, it gets trickier since JQL doesn’t track all user interactions. For that, you might explore issue history with Marketplace apps like ScriptRunner or JQL Search Extensions that let you search by activity.

Hope this helps! 😊

[pvala_micron_com]

Thanks @Brita Moorus

[Trudy Claspill · Accepted solution]

Hello @pvala_micron_com 

Welcome to the Atlassian community.

The above JQL provided by @Brita Moorus is not quite what you need. Breaking it into its components:

(created >= "2025-01-01" AND created <= "2025-01-31")

That will get you issues created inclusively between two dates.

(created >= "2025-01-01" AND created <= "2025-01-31")
AND
creator = currentUser()

That will get you the issues that you created between those two dates, regardless of whether or not you are also named as the Reporter of the issue.

((created >= "2025-01-01" AND created <= "2025-01-31")
AND
creator = currentUser())
OR
(updated >= "2025-01-01" AND updated <= "2025-01-31")

That will get you the issues you created between the two dates PLUS any issue updated between the two dates, not just the issues updated by you.

In order to meet your requirement of getting the issues updated by you you would need Jira to support something like this:

((created >= "2025-01-01" AND created <= "2025-01-31")
AND
creator = currentUser())
OR
((updated >= "2025-01-01" AND updated <= "2025-01-31")
AND
updater = currentUser())

Unfortunately Jira does not natively support filtering for items updated within a date range while simultaneously filtering based on who made the updates - there is no "updater" field to use in JQL

There is a special Operator named CHANGED which can be used with a small set of fields to filter for issues where the specified field was "changed by <user> after <date> before <date>". Refer to this documentation:

https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#CHANGED

However as noted in that documentation that works on a very limited number of fields so you cannot use it to get the issues where you made changes to fields not supported by the operator.

As mentioned by @Brita Moorus getting more complex filtering for issues that you updated would require a third party app. You would need to consider what types of updates you would want include - updates to fields, addition/removal/editing of Comments, addition/removal/editing of Work Logs, etc.

[pvala_micron_com]

Thanks @Trudy Claspill

[Natalia_Kovalchuk_SaaSJet_]

Hi @pvala_micron_com!

JQL has some limitations when it comes to date range filtering, particularly in combining multiple conditions simultaneously. 

However, you can try to use such JQL queries in your case:

• To get the list of issues that were created between two dates:

creator = currentUser() AND created >= "2025-01-01" AND created <= "2025-01-31"

• To get the list of issues updated between two dates:

assignee = currentUser() AND updated >= "2025-01-01" AND updated <= "2025-01-31"

Unfortunately, JQL doesn’t support combining created OR updated into a single condition.

Additionally, you can try the Issue History for Jira app, which is provided by my team. Using it, you will be able to get the full change history and filter by:

• User (who made the change)

• Date range (between two dates)

• Specific fields changed (such as status, assignee, updated, created, etc.).

With the help of the Issue History app, you can quickly check which issues you’ve created and updated within a specific date range, with no need to use JQL. For example:

Here’s a quick look at the app: Issue History for Jira on Atlassian Marketplace.

Hope I could help you!