Feature #10944

Query for activity

Added by St├ęphane Gourichon over 10 years ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Issues
Target version:-
Resolution:

Description

When working with redmine, one sometimes needs queries based on activity history.

Basically, current "activity" tab and the "history" section of every issue page do perform a fixed query.
It would be helpful to allow users to perform a variety of queries.

Examples of meaningful queries :
  • list all activities of user john from date X to date Y
  • list all activities that reopen a bug from date X to date Y
  • list all activities that change assignee from date X to date Y
  • list all activities that change custom field F with previous value V, from date X to date Y
  • list all activities on bug ID=1234 where comment contains "foo"
  • list all activities without a comment

Like with current activity tab, the answer is a list of activity entries, not issues, so an issue ID may appear many times.

Notice that the examples above do not involve join with issues, they query only on fields of activity entries themselves.

Also available in: Atom PDF