Dynamic query fields
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.
#1 Updated by Andrey Anufrienko over 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 over 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.