プロジェクト

全般

プロフィール

Vote #63684

未完了

add custom fields that are calculations of other fields

Admin Redmine さんが7ヶ月前に追加. 7ヶ月前に更新.

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

0%

予定工数:
category_id:
14
version_id:
0
issue_org_id:
1712
author_id:
1538
assigned_to_id:
0
comments:
48
status_id:
1
tracker_id:
2
plus1:
35
affected_version:
closed_on:
affected_version_id:
ステータス-->[New]

説明

My company wants to score issues on a issue level rather than a project level. In order to do so we'd like a custom field that can be a calculation based on other issue fields. For example, we could have a custom field called score that would be a sum of priority * custom field priority_weight + time_estimate * custom field time_est_weight + custom field risk * custom field risk_weight + custom filed income_potential * custom field income_potential_weight, where weight would be some number between -10 and 10.

Adding custom fields that allowed calculation would give us the flexibility to do this. The field could be something like a formula field in a google doc spreadsheet. ie: my_custom_field = if(est_time > 3, 10, 5)*est_time_weight

That might be a lot to do, but it would be the ultimate in flexibility. All we need is simple addition/subtraction and multiplication. Although multiplying times "severity" field might be hard if it isn't an integer already.

Is it possible to sponsor work? If so, how much does it cost? (I ask without yet having the boss's approval mind you).


journals

+1
Support the motion. In my company something very similar is needed: a field priority, which is calculated from the issue's "business_value" and "development_effort" ie priority is highest when business value is greatest and development_effort is lowest, and vice-versa.

Chris
--------------------------------------------------------------------------------
+1

We would find this possibility also very useful.
--------------------------------------------------------------------------------
+1
I also would like a custom aggregate field to be exposed in custom aggregated queries.
--------------------------------------------------------------------------------
+1
We would need it to. I just wanted to create a new Issue for this, but I found this one here.
Could a developer of redmine please post some opinions or informations about this?
If we would know more about it and redmine internals we even would be able to contribute to redmine project.
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1 this issue is over 3 years old but it is interesting. Is it meant to be scheduled?
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1 http://www.easyredmine.com/online-store/easy-redmine-plugins/computed-custom-fields
--------------------------------------------------------------------------------
+1
Our guys wants to see issue age in the issue list.
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1

Some news?

--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+ 999999999 :-)
--------------------------------------------------------------------------------

--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------

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

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

--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
I made a plugin with similar functionality. You can try it https://www.redmine.org/plugins/computed_custom_field
--------------------------------------------------------------------------------
This sounds great.
Would there be the possibility to include standard fields (like estimated work, remaining work) from Redmine objects (trackers, users, projects) in the calculation? Or do you support custom fields only for now?

Regards
Ingo

Yakov Annikov wrote:
> I made a plugin with similar functionality. You can try it https://www.redmine.org/plugins/computed_custom_field

--------------------------------------------------------------------------------
Yakov Annikov wrote:
> I made a plugin with similar functionality. You can try it https://www.redmine.org/plugins/computed_custom_field

I have tested it and I like it. It is simple and does work very well. The only nuisance is that computed custom field is editable when adding or editing issues. I thing the views\issues\_form_custom_field.html.rb should be adjusted to not render computed custom fields. As a workaround, the computed field can be set as read only using workflow permissions.

I would vote for adding this to Redmine core! This is very small change but it gives huge possibilities.

Can you convert it into patch and add tests? It would be easier to convince JPL to include it :)
--------------------------------------------------------------------------------
Ingo Gellrich wrote:
> This sounds great.
> Would there be the possibility to include standard fields (like estimated work, remaining work) from Redmine objects (trackers, users, projects) in the calculation? Or do you support custom fields only for now?
>
> Regards
> Ingo
>
> Yakov Annikov wrote:
> > I made a plugin with similar functionality. You can try it https://www.redmine.org/plugins/computed_custom_field

It is possiblle to use standart methods and fields of objects, for example a formula of Issue CF:
<pre>
(self.estimated_hours || 0) * 2
</pre>

--------------------------------------------------------------------------------
Sebastian Paluch wrote:
> Yakov Annikov wrote:
> > I made a plugin with similar functionality. You can try it https://www.redmine.org/plugins/computed_custom_field
>
> I have tested it and I like it. It is simple and does work very well. The only nuisance is that computed custom field is editable when adding or editing issues. I thing the views\issues\_form_custom_field.html.rb should be adjusted to not render computed custom fields. As a workaround, the computed field can be set as read only using workflow permissions.
>
> I would vote for adding this to Redmine core! This is very small change but it gives huge possibilities.
>
> Can you convert it into patch and add tests? It would be easier to convince JPL to include it :)

Thank you for your note. The plugin is still in development. Maybe patch and test would be later.
--------------------------------------------------------------------------------
thx alot yakov aanikov

can u see the pic attachment
i need use this in 3 way
#1 project , #2 sub project , # 3 issue (a) , 4# issue (b)
* in issue #3 we have traker GOAL and we create 3 task tracker TASK
* in issue #4 we have traker result
1- collect custom field from subtask to task leverl
2- collect custom field from task to tracker level
3 collect custom field from all issiue to issiue
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
yakov aanikov: https://www.redmine.org/plugins/computed_custom_field - This project is no longer maintained - compatible with Redmine 4.0.x, and what about Redmine 4.1?

This feature is very needed.

--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------

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


related_issues

relates,New,8177,Custom Field with mathematical calculation
relates,Closed,36992,redmine computed custom field
duplicates,Closed,8599,Calculated Custom Field?
duplicates,Closed,17535,Custom fields maths
duplicates,Closed,17582,advanced awesome calculated computed custom fields

Admin Redmine さんが7ヶ月前に更新

  • カテゴリCustom fields_14 にセット

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

いいね!0
いいね!0