Filter all issues that have been updated last month

Hi,

I would like to list all JIRA issues which have been updated within last month

I've tried to use updated field but it is related to Last Updated time. I'm looking for a query which would return me the list of all issues that have been updated in a specific time period.

Consider the following scenario:

  1. An issue has been updated on 15/07 - last updated = 15/07
  2. The same issue is updated on 10/08 - last updated = 10/08

What JQL would I use to return all issues updated in June?

Thanks,
Maurycy

7 answers

1 vote

Maurycy,

If you're looking for a specific type of update (if the status changed, for example) you can use the 'CHANGED' operator. You can query using: status CHANGED AFTER "2014-06-01" BEFORE "2014-07-01", for example. See https://confluence.atlassian.com/display/JIRA/Advanced+Searching#AdvancedSearching-CHANGED

I hope this helps!

Matheus,

That would work if CHANGED operator is not restricted to Assignee, Fix Version, Priority, Reporter, Resolution and Status fields only.

I would need to check if COMMENT has been changed (updated) or if a work log has been updated (a user has logged time spent against an issue)

Thanks,
Maurycy

I need this as well has there been any progress on this?

Hi, this my plugin

https://marketplace.atlassian.com/plugins/ru.andreymarkelov.atlas.plugins.utils

has functions:

  • My commented issues JQL Function. This is JQL function "commentedIssues(?)" which returns list of issues that commented of current logged user beginning from ? (in duratioon format 2h, 2d).

  • User commented issues JQL Function. This is JQL function "userCommentedIssues(?1, ?2)" which returns list of issues that commented of user ?1 beginning from ?2 (in duratioon format 2h, 2d).

Examples:

issue in commentedIssues("2d")

issue in userCommentedIssues("admin", "2d")

Andrey,

Sounds great - that's almost what I'm looking for.

Just to confirm - your plugin returns list of all isuses that have been commented by currently logged on user. I'm looking for a function which returns issues that have been commented by any user for a specified date range e.g. between -60D and -30D rather than commented in last 2 days

Could your plugin be extended or configured to cover such requirement?

Thanks,
Maurycy.

Maurycy,

Only by loggedIn user or spacified user.

-- Andrey

Andrey,

Is it possible to specify list of users?

Thanks,
Maurycy

Please, create the feature in my tracker. Will do in queue

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Tuesday in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

225 views 1 18
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you