WIKI macro to insert database query result as wiki table
This is a tool very useful for us and is implemented in Attlasian Confluence
In essence you can write any "SELECT" query and confluence
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.
#2 Updated by Felix Sendino over 10 years ago
I understand, it is solved in confluences as you define the query on a datasource, so the administrator can control which tables are visible to the querys.
I think it could be solved in a similar way, maybe accesing to a parallel database ad-hoc for the macro.
Or you could make the macro add a prefix to the table names, so only this tables would be accesible and it would depend on system-level setup
Jean-Philippe Lang wrote:
This kind of macro would be pretty easy to write but totally unsafe.
#3 Updated by Benny The Bouncer over 10 years ago
This would be extremely useful.
Having moved from trac to Redmine recently the one thing I'm missing is this kind of expert mode. People with database expertise are overly restricted in Redmine. As an example, we had a closed issues report grouped by calendar week descending. Same goes for the images width.
Re security concerns - why not distinguish between private and public projects? Let users decide (within limits) how restrictive their installation should be.