Project

General

Profile

Feature #949

WIKI macro to insert database query result as wiki table

Added by Felix Sendino over 7 years ago. Updated over 7 years ago.

Status:
新規(New)
Priority:
通常(Normal)
Assignee:
Start date:
02/13/2012
Due date:
% Done:

0%

Estimated time:

Description

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.

History

#1

Updated by Haru Iida over 7 years ago

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.

#2

Updated by Haru Iida over 7 years ago

  • Project changed from r-labs to Wiki Extensions
  • Assignee set to Haru Iida
#3

Updated by Haru Iida over 7 years ago

  • Target version changed from 0.3.9 to いつかやる(Unplanned)
#4

Updated by Felix Sendino over 7 years ago

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

Also available in: Atom PDF