プロジェクト

全般

プロフィール

Vote #78649

完了

Issue Query: inconsistency between spent_hours sum and sum of shown spent_hours values

Admin Redmine さんが3年以上前に追加. 3年以上前に更新.

ステータス:
Closed
優先度:
通常
担当者:
-
カテゴリ:
Issues list_58
対象バージョン:
開始日:
2022/05/09
期日:
進捗率:

0%

予定工数:
category_id:
58
version_id:
133
issue_org_id:
26471
author_id:
40856
assigned_to_id:
1
comments:
4
status_id:
5
tracker_id:
1
plus1:
0
affected_version:
closed_on:
affected_version_id:
132
ステータス-->[Closed]

説明

Steps to reproduce:

  • Create two projects A and B, enable the spent time module only in A.
  • Create issues in A and log time for them.
  • Move one of these issues to B.
  • go to /issues, configure filters so all issues created in step two are shown, add the Spent time column and also tick the Spent time checkbox in the Totals row.

Result:

The Spent time sum shown above the table is the sum of the time logged in step two, though the issue moved to B shows 0 in the Spent Time column. (because the module is disabled in Project B and thus it's time entries aren't @visible@ anymore).

Expected Result:

The total should be the sum of the values shown for each issue in the corresponding column.

Easiest way to fix it would certainly be to fix the totals computation so it only includes hours from visible time entries. In addition to the module enabled / disabled situation described above, it might also be that, with an enabled spent time module in B, but given I do not have permission to see time entries in B, the moved issues' time entries are still counted. This issue would be fixed with above solution as well I think.

The sum should (preferably only if we know it isn't complete) be amended with a hint (footnote or something else) informing the user that this sum is (or possibly is) not the complete sum due to permissions / modules not being enabled).


journals

This should be fixed in r16839. It also fixes the behaviour of sorting issues by spent_hours.
--------------------------------------------------------------------------------
> The sum should (preferably only if we know it isn't complete) be amended with a hint (footnote or something else) informing the user that this sum is (or possibly is) not the complete sum due to permissions / modules not being enabled).

This is not part of the fix. There are many place where this hint could be added if it's needed. We should track it in a separate feature request.
--------------------------------------------------------------------------------
Thanks for the quick fix!

Jean-Philippe Lang wrote:
> > The sum should (preferably only if we know it isn't complete) be amended with a hint (footnote or something else) informing the user that this sum is (or possibly is) not the complete sum due to permissions / modules not being enabled).
>
> This is not part of the fix. There are many place where this hint could be added if it's needed. We should track it in a separate feature request.

I created #26491 for this.
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------

Admin Redmine さんが3年以上前に更新

  • カテゴリIssues list_58 にセット
  • 対象バージョン3.4.3_133 にセット

他の形式にエクスポート: Atom PDF

いいね!0
いいね!0