プロジェクト

全般

プロフィール

Vote #71023

未完了

Custom field , value list from database query

Admin Redmine さんが3ヶ月前に追加. 3ヶ月前に更新.

ステータス:
New
優先度:
通常
担当者:
-
カテゴリ:
Custom fields_14
対象バージョン:
-
開始日:
2022/05/09
期日:
進捗率:

0%

予定工数:
category_id:
14
version_id:
0
issue_org_id:
9734
author_id:
33303
assigned_to_id:
0
comments:
15
status_id:
1
tracker_id:
2
plus1:
9
affected_version:
closed_on:
affected_version_id:
ステータス-->[New]

説明

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

Admin Redmine さんが3ヶ月前に更新

  • カテゴリCustom fields_14 にセット

他の形式にエクスポート: Atom PDF

いいね!0
いいね!0