Project

General

Profile

Actions

Feature #9734

open

Custom field , value list from database query

Added by Felix Sendino over 12 years ago. Updated about 3 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Custom fields
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
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

Related to Redmine - Feature #6717: Custom list field with dynamic list contentNew2010-10-21

Actions
Related to Redmine - Feature #22026: Conditional custom fieldsNew

Actions
Has duplicate Redmine - Feature #12224: Custom Fields with SQL FormatClosed

Actions
Has duplicate Redmine - Feature #19237: Get data from database to custom fieldClosed

Actions
Actions #1

Updated by Daniel Felix over 11 years ago

+1

Actions #2

Updated by Martin G about 11 years ago

+1

Actions #3

Updated by Dipan Mehta over 10 years ago

Add related #6717

Actions #4

Updated by Toshi MARUYAMA over 10 years ago

  • Related to Feature #6717: Custom list field with dynamic list content added
Actions #5

Updated by Maicon Zucco over 9 years ago

+1

Actions #6

Updated by Alice Etchegaray over 9 years ago

+1

Actions #7

Updated by Esteban Barrios about 9 years ago

+1

Actions #8

Updated by Toshi MARUYAMA about 9 years ago

  • Has duplicate Feature #19237: Get data from database to custom field added
Actions #9

Updated by Ami Desai almost 9 years ago

+1

MUST wanted feature.

Actions #10

Updated by Toshi MARUYAMA almost 8 years ago

Actions #11

Updated by Teogenes da Nobrega over 7 years ago

+1

Actions #12

Updated by [ Desperados ] over 7 years ago

+1

Actions #13

Updated by Amir Sepahram over 3 years ago

+1

Actions #15

Updated by QMB ENTW about 3 years ago

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

Actions

Also available in: Atom PDF