nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter all issues that have been updated last month

Maurycy Widera

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:

An issue has been updated on 15/07 - last updated = 15/07
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

Accepted answers

All comments

Matheus Fernandes

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!

Maurycy Widera

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

Andrey Markelov

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")

Maurycy Widera

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