How to create a query where I can get fields calculation from each other?

Added by Tyler Durden about 5 years ago

Hello!
I'm using 2.1 redmine branch.
Is it possible to build an issues query where one date field get compared with another date field?
The basic functionality offers compare the date fields with fixed hard-coded dates. So I want something like an ordinary SQL.

Replies (4)

RE: How to create a query where I can get fields calculation from each other? - Added by Jean-Philippe Lang almost 5 years ago

Sorry, this feature is not implemented. Which dates would you like to compare?

RE: How to create a query where I can get fields calculation from each other? - Added by Tyler Durden almost 5 years ago

Thank you for reply.
I've created the custom issue field (say "Deadline Date") and the task has predefined fields - "Start Date" and "End Date".
I need to construct the issue query where for example End Date < Deadline Date or (Deadline Date - End Date)>=3.

RE: How to create a query where I can get fields calculation from each other? - Added by John Gordon over 3 years ago

This would be a really good addition to allow for example two custom field vlaues to be multiplied together to create the value for a third. An example of using this would be to add risk scores to issues so impact and probability and then multiply them to get total risk value for the issue in the project.
Easy Redmine do this in their custom implementation but it does not appear to be compatible with Redmine. What a pity Easy Redmine! Adding colour to this by level of value would be even neater ie in a RAG sort of way. RAG = Red Amber Green.

(1-4/4)