Feature #949
未完了WIKI macro to insert database query result as wiki table
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.
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 DatasourceThis 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