Vote #71852
未完了Query for activity
ステータス:
New
優先度:
通常
担当者:
-
カテゴリ:
Issues_2
対象バージョン:
-
開始日:
2022/05/09
期日:
進捗率:
0%
予定工数:
Redmineorg_URL:
category_id:
2
version_id:
0
issue_org_id:
10944
author_id:
34972
assigned_to_id:
0
comments:
0
status_id:
1
tracker_id:
2
plus1:
0
affected_version:
closed_on:
affected_version_id:
説明
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.
いいね!0