プロジェクト

全般

プロフィール

Feature #949

未完了

WIKI macro to insert database query result as wiki table

Felix Sendino さんが約12年前に追加. 約12年前に更新.

ステータス:
新規(New)
優先度:
通常(Normal)
担当者:
対象バージョン:
開始日:
2012/02/13
期日:
進捗率:

0%

予定工数:

説明

This is a tool very useful for us and is implemented in Attlasian Confluence
In essence you can write any "SELECT" query on a database instance connected via Datasource

This could be translated to have a macro which would translate the query dataset into a wiki table,
I've noticed wiki_extensions_ref_issues , uses issues.controller but it would be more flexible
to be able to write an sql query.

It's very useful to integrate inventary and CMDB information anywhere in redmine.
With a tool like REDMINE would become very ITIL'friendly as it would be use as project, cmdb , kb, and issues portal
Our idea would be to insert cmdb tables into redmine's mysql and to publish tables from it.
To insert query's as wiki tables gives a lot of flexibility.

Haru Iida さんが約12年前に更新

Thanks for your idea.

I think it's interesting but it contains security problem.
It makes any user could see any project's data or any user's private issues.

Haru Iida さんが約12年前に更新

  • プロジェクトr-labs から Wiki Extensions に変更
  • 担当者Haru Iida にセット

Haru Iida さんが約12年前に更新

  • 対象バージョン0.3.9 から いつかやる(Unplanned) に変更

Felix Sendino さんが約12年前に更新

Felix Sendino は書きました:

This is a tool very useful for us and is implemented in Attlasian Confluence
In essence you can write any "SELECT" query on a database instance connected via Datasource

This could be translated to have a macro which would translate the query dataset into a wiki table,
I've noticed wiki_extensions_ref_issues , uses issues.controller but it would be more flexible
to be able to write an sql query.

It's very useful to integrate inventary and CMDB information anywhere in redmine.
With a tool like REDMINE would become very ITIL'friendly as it would be use as project, cmdb , kb, and issues portal
Our idea would be to insert cmdb tables into redmine's mysql and to publish tables from it.
To insert query's as wiki tables gives a lot of flexibility.

i've noticed this issue has been asigned,
i think we may workaround the security issues setting the queryable tables at project config level
and parse the query from clause against this list

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