プロジェクト

全般

プロフィール

Vote #73607

完了

Filters will show issues with unused custom fields.

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

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

0%

予定工数:
category_id:
14
version_id:
70
issue_org_id:
13537
author_id:
74877
assigned_to_id:
1
comments:
3
status_id:
5
tracker_id:
1
plus1:
0
affected_version:
closed_on:
affected_version_id:
63
ステータス-->[Closed]

説明

If I create a filter that looks for a particular value in a custom field,
issues that are in a project where the custom field has been removed
will show up as matches. This is strange and annoying! Why should a filter
match if the custom field is inactive in the project settings that
the searched issue belongs to?

Another way to explain this is that the results from this SQL-query
should not be returned when you search with a custom-field filter.

select 
    i.id, p.name, concat("\"", cv.value, "\"")
from 
    issues i, projects p, custom_values cv                             
where 
    i.project_id = p.id and
    i.id = cv.customized_id and
    cv.custom_field_id not in 
        (select custom_field_id from custom_fields_projects where p.id = project_id)
order by name, custom_field_id;

journals

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

--------------------------------------------------------------------------------
The same happens if a field is disabled on a tracker. This is fixed in r12133, thanks for pointing this out.
--------------------------------------------------------------------------------

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

  • カテゴリCustom fields_14 にセット
  • 対象バージョン2.4.0_70 にセット

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

いいね!0
いいね!0