Feature #9734
open
Custom field , value list from database query
0%
Description
This would help to use redmine issues referenced to a resource inventory,
or a CMDB.
Basically we'd insert cmdb data into redmine mysql tables and we'd like to define
a custom field based on query results, for example, select service_name from service_list,
and set it as a required field for defined trackers.
As it would be a very long list it would be perfect to have the query "dynamically" executed by
another value, which would be used in the where clause.
For example, we would have a Category custom field (database, system, hardware) and would use the
value to shorten the query defined.
Related issues
Updated by 
Updated by 
Updated by
Updated by Toshi MARUYAMA almost 11 years ago
- Related to Feature #6717: Custom list field with dynamic list content added
Updated by 
Updated by 
Updated by
Updated by Toshi MARUYAMA over 9 years ago
- Has duplicate Feature #19237: Get data from database to custom field added
Updated by
Updated by Toshi MARUYAMA over 8 years ago
- Related to Feature #22026: Conditional custom fields added
Updated by 
Updated by 
Updated by
Updated by Alexey Smirnov almost 4 years ago
Updated by QMB ENTW almost 4 years ago
Alexey Smirnov wrote:
Hi Alexey, can you support some examples how it works?
Are there some restrictions for SQL-queries?
I'm very familar to SQL, but what are the parameter-definitions to any SQL-query?
And do the query depends on the ID of an issue?
Kind regards Klemens