Project

General

Profile

Actions

Feature #10943

open

Query issues based on activity history

Added by Stéphane Gourichon over 12 years ago. Updated almost 6 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Issues filter
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Resolution:

Description

Feature description

When working with redmine, one sometimes needs to query for issues based on their history.

The example I need on a regular basis is to list issues that were updated during given time period (each involved issue would appear once even if many updates).

Search before post

I have searched wiki, issues, found related material, e.g. #4077 #971. These are oriented towards "time spent" entries, which are kind of activity entries. The closest thing I found is issue #10454 where the author expected the behavior described here on a search on "updated" field.

What does feature involve technically ?

Technically, it would be additional query criteria in the issue query tab. To put the possibilities verbosely for clarity :
  • issue history has entry with date before/after/...
  • issue history has entry that changes issue regular field
  • issue history has entry that changes issue custom field
  • issue history has entry that changes "assigned" from "john" to "jane"
  • issue history has entry that add comment
  • issue history has entry that add comment containing "text"
  • issue history has entry that attaches file ...

Comparison with existing

Jira handles queries on updated field like redmine.

Jira allows some history-oriented queries that, to my knowledge, Redmine does not handle. Below are valid Jira advanced searches.

status WAS in ("Resolved","Closed") DURING ("2012-04-01","2012-05-31") order by assignee
assignee "CHANGED":http://confluence.atlassian.com/display/JIRA/Advanced+Searching#AdvancedSearching-CHANGED
status CHANGED FROM "In Progress" TO "Open" 

Summary

Request ability to query for issues that were updated during a certain time range, in usual query tool (with display by columns, sort, group by, etc).


Related issues

Related to Redmine - Feature #17720: Filter issues by "Updated by" and "Last updated by"ClosedJean-Philippe Lang

Actions
Actions #1

Updated by Anthony HERBÉ over 10 years ago

It would be nice indeed.

Actions #2

Updated by Jonas De Meulenaere about 7 years ago

+1

Actions #3

Updated by Mischa The Evil about 7 years ago

FWIW: Redmine 3.4.0 introduced 'Updated by' and 'Last updated by' query filters via #17720, which might have solved (some of) the use cases described here.

Actions #4

Updated by Go MAEDA about 7 years ago

  • Category changed from Issues to Issues filter
Actions #5

Updated by Go MAEDA about 7 years ago

  • Related to Feature #17720: Filter issues by "Updated by" and "Last updated by" added
Actions

Also available in: Atom PDF