Vote #71023
未完了Custom field , value list from database query
0%
説明
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.
journals
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
Add related #6717
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
+1
MUST wanted feature.
--------------------------------------------------------------------------------
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
+1
--------------------------------------------------------------------------------
https://www.redmine.org/plugins/custom_field_sql
--------------------------------------------------------------------------------
Alexey Smirnov wrote:
> https://www.redmine.org/plugins/custom_field_sql
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
--------------------------------------------------------------------------------
related_issues
relates,New,6717,Custom list field with dynamic list content
relates,New,22026,Conditional custom fields
duplicates,Closed,12224,Custom Fields with SQL Format
duplicates,Closed,19237,Get data from database to custom field