Feature #15177

Dynamic query fields

Added by Andrey Anufrienko almost 4 years ago. Updated almost 4 years ago.

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

0%

Category:Custom fields
Target version:-
Resolution:

Description

All custom fields are set in 'static' manner - we have to enter a value.
But often we need to calculate a value basing on other fileds/attributes values.

Example 1 (issues). I have 3 custom fields for my issues: A, B, C that represents parts of expression (Ax2 + Bx + C = 0).
If I want to see Y1 and Y2 such as:
Y1 = (B + SQRT (B*B - 4A*C)) / 2A
Y1 = (B - SQRT (B*B - 4A*C)) / 2A
I have to export all issues to CSV, then import CSV into Excel, then add formulas to make the calculation. It would be great if I could add specific columns in my custom query that will calculate value basing on custom expression each time I refresh the window.

Example 2 (version). I have 1 custom field A for each issue. I want to see sum of all A for a particular version.
Again, I have to export all my data to an external application and make calculation there.


Related issues

Related to Redmine - Feature #6717: Custom list field with dynamic list content New 2010-10-21

History

#1 Updated by Andrey Anufrienko almost 4 years ago

Now, I use database triggers to work around this issue: my database records are updated automatically each time custom field are updated. But it has cons: if I re-install / upgrade redmine I would re-design my triggers. Also, sometimes redmine 'misses' changes - they are not shown in auto emails. And other disadvantages are.

#2 Updated by Andrey Anufrienko almost 4 years ago

Example 3 (versions + issues). I have 1 global coefficient for each version. I need to multiply an attribute from issue to this global coefficient. Again, I have to export into CSV, then to Excel or implement a trigger in database to show required value.

#3 Updated by Toshi MARUYAMA over 2 years ago

  • Related to Feature #6717: Custom list field with dynamic list content added

Also available in: Atom PDF