Feature #949
未完了
WIKI macro to insert database query result as wiki table
Felix Sendino さんが約12年前に追加.
約12年前に更新.
説明
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.
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.
- プロジェクト を r-labs から Wiki Extensions に変更
- 担当者 を Haru Iida にセット
- 対象バージョン を 0.3.9 から いつかやる(Unplanned) に変更
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