Project

General

Profile

Actions

Feature #6717

open

Custom list field with dynamic list content

Added by Stefano Lenzi over 13 years ago. Updated almost 3 years ago.

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

0%

Estimated time:
Resolution:

Description

Use Case

The administrator of the Galaxy project adds a new custom list field "affected version", which contains all the version defined for Galaxy project, so that when a new version is created the administrator does not have to add it to list manually

Query solution

When creating a custom field of type list the text area dedicated to the list content could contain a SQL query that will be used for populating the list when the field is shown. For legacy purpose, a checkbox "dynamic list" is shown which if select would use the SQL query


Related issues

Related to Redmine - Feature #6716: Linking version to categoryNew2010-10-21

Actions
Related to Redmine - Feature #2096: Custom fields referencing system tables (users and versions) ClosedJean-Philippe Lang2008-10-27

Actions
Related to Redmine - Feature #13016: Dynamic adding values to custom fieldsNew

Actions
Related to Redmine - Feature #9734: Custom field , value list from database queryNew

Actions
Related to Redmine - Feature #13143: Populate dropdown custom field list based on previous another selection New

Actions
Related to Redmine - Feature #15177: Dynamic query fieldsNew

Actions
Related to Redmine - Feature #19224: Custom fields / List - make user editableNew

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

Actions
Actions #1

Updated by Stefano Lenzi over 13 years ago

The General Solution of issue #6716 would enhance even more the flexibility of the issue module to adapt easily to company needs, it also increases the usability and reduce the compilation time of the Issues.

Actions #2

Updated by Fernando Hartmann about 13 years ago

+1

This is really near as what we need, we need a custom field filed by a query that retrieve our customers list from the ERP table, but this ERP is on other database, so, there must be some connection information too. Then this query can access other databases !

Actions #3

Updated by Terence Mill about 13 years ago

Stefano Lenzi wrote:

The General Solution of issue #6716 would enhance even more the flexibility of the issue module to adapt easily to company needs, it also increases the usability and reduce the compilation time of the Issues.

Huh! That would be a nice feature indeed. Instead of SQL Queries to froreign Databases, support for a common standard(?) http WS protocol for data queries would be better. So every dataprovider can offer its data "lists" via a web service where data can ve queried ad search results get returned. Someone has an idea what standards there are?

Actions #4

Updated by Terence Mill about 13 years ago

This is related to Issue #2096

Actions #5

Updated by Dipan Mehta about 11 years ago

While most usage will be served well with having Versions and Users type fields it would be really nice if the scope of this ticket is made extensible from there:

there are two specific cases where this can be thought of :

1. The custom fields which has many set of 'possible values' list:

The dynamic lists exists for many things - e.g. resources being used, configuration properties, OS and platform specific etc. In particular case, we use a config specific field with an almost same named field - in each project. So the purpose and role of that field is same in all projects- but it is actually a different custom field just because the list of "Possible values" is different in each project! And let me tell you, it's easier said than done when we 'create' these fields. All aspects of works flows - where in each state/tracker/role where the particular field become 'must', 'read-only', permissions and a whole set of things now needs to be repeated for each project. And then, when we create another project? do this whole thing all over again.

How this can be implemented: Ideally, it is very important that a given Dynamic List can have multiple set of possible-list-of-values, and either the source list can be selected in project. Alternatively, we can put a complete list of possible values in the main definition - and then specific projects can enable disable the fields that suits them. But even as the possible values differ per project actual workflow and behavior can remain as is for all aspects.

Actions #6

Updated by Dipan Mehta about 11 years ago

2. Custom fields which derive values dependent from external system:

The Request Tracker ticketing system has something called an External Fileds . A potential use case could be to hook to external systems - e.g. I can lookup on the external Inventory systems to know the list of machines that can apply for the given context, or a list of versions of external platforms -e.g. Ruby, or Chrome or even list of stable Linux versions, or for that matter Bug numbers, Test cases of external systems etc. In our case can also be a specific lists related to config parameters without which the bugs are hard to reproduce. The essence is that the system which populates such a list is essentially external to Redmine and hence it would be wrong to keep manually updating the admin to keep adding items such as this inside the table list. Also the relevance could change depending on the project - hence the said list could be unique for each project.

How should this be implemented? : Definitely calling upon external DB directly could be very wrong. And currently i see no webserivce standard's schema exists for such a purpose, and ideally, even if we try to create one, it's not practical to apply everywhere. The way it should be done should be very similar to how email based issue creation works. There should be a REST API that exposes a given custom_field ID and it's possible current values can be updated. Now one can write any script on ones' own that fetches the right set of list from whatever appropriate place and run a cron-type job to keep updating this! Even the current custom_fields can be very easily extended in this manner. One very critical thing to support is that in the history some fields could have been valid - so they could exist in DB, but now they might not be among the possible values - this needs to be supported.

Actions #7

Updated by Dipan Mehta over 10 years ago

Any feedback or update on this?

Actions #8

Updated by Toshi MARUYAMA over 10 years ago

  • Related to Feature #13016: Dynamic adding values to custom fields added
Actions #9

Updated by Toshi MARUYAMA over 10 years ago

  • Related to Feature #9734: Custom field , value list from database query added
Actions #10

Updated by Toshi MARUYAMA over 10 years ago

  • Related to Feature #13143: Populate dropdown custom field list based on previous another selection added
Actions #11

Updated by Maxime Vez almost 10 years ago

+1

Actions #12

Updated by Maicon Zucco over 9 years ago

+1

Actions #13

Updated by Yar n over 9 years ago

one more vote.

Actions #14

Updated by Alice Etchegaray over 9 years ago

+1

Actions #15

Updated by Toshi MARUYAMA over 9 years ago

  • Category changed from Issues to Custom fields
Actions #16

Updated by sebastien lemaitre about 9 years ago

+1

Actions #17

Updated by Andrey Tatarnikov almost 9 years ago

+1

Actions #18

Updated by Toshi MARUYAMA almost 9 years ago

Actions #19

Updated by Toshi MARUYAMA over 8 years ago

  • Related to Feature #19224: Custom fields / List - make user editable added
Actions #20

Updated by Dipan Mehta almost 8 years ago

Is this coming anytime soon?

Actions #21

Updated by Toshi MARUYAMA almost 8 years ago

Actions #22

Updated by Jefferson Campos almost 8 years ago

Is this coming anytime soon? I din't find it in roadmap. This feature would be very very usefull.

Actions #23

Updated by Mei Chua over 7 years ago

+1

Actions #24

Updated by Vincent Bruggeman almost 7 years ago

+1

Actions #25

Updated by Roberto Vieweg over 6 years ago

+1

Actions #26

Updated by Amir Sepahram over 3 years ago

+1

Actions #28

Updated by Alexandr Chernyaev almost 3 years ago

+1

Actions

Also available in: Atom PDF