Feature #9734
Custom field , value list from database query
Status: | New | Start date: | ||
---|---|---|---|---|
Priority: | Normal | Due date: | ||
Assignee: | - | % Done: | 0% | |
Category: | Custom fields | |||
Target version: | - | |||
Resolution: |
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
History
#1
Updated by Daniel Felix over 9 years ago
+1
#2
Updated by Martin G over 9 years ago
+1
#3
Updated by Dipan Mehta over 8 years ago
Add related #6717
#4
Updated by Toshi MARUYAMA over 8 years ago
- Related to Feature #6717: Custom list field with dynamic list content added
#5
Updated by Maicon Zucco almost 8 years ago
+1
#6
Updated by Alice Etchegaray almost 8 years ago
+1
#7
Updated by Esteban Barrios about 7 years ago
+1
#8
Updated by Toshi MARUYAMA about 7 years ago
- Duplicated by Feature #19237: Get data from database to custom field added
#9
Updated by Ami Desai about 7 years ago
+1
MUST wanted feature.
#10
Updated by Toshi MARUYAMA about 6 years ago
- Related to Feature #22026: Conditional custom fields added
#11
Updated by Teogenes da Nobrega almost 6 years ago
+1
#12
Updated by [ Desperados ] over 5 years ago
+1
#13
Updated by Amir Sepahram almost 2 years ago
+1
#15
Updated by QMB ENTW over 1 year 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