Feature #9733
open
WIKI macro to insert database query result as wiki table
Added by Felix Sendino almost 13 years ago.
Updated almost 13 years ago.
Description
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.
This kind of macro would be pretty easy to write but totally unsafe.
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.
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.
Anyway, could this be written as a plugin, (just as "wiki extensions")
so you could enable it per-project and this way restrict security
If so, could you point us to the code (we are no rails experts)?
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by