Project

General

Profile

Actions
Copy link

Feature #949

open

WIKI macro to insert database query result as wiki table

Feature #949: WIKI macro to insert database query result as wiki table

Added by Felix Sendino about 14 years ago. Updated almost 14 years ago.

Status:
新規（New）
Priority:
通常（Normal）
Assignee:
Haru Iida
Target version:
いつかやる(Unplanned)
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.

Updated by Haru Iida about 14 years ago Actions
Copy link
 #1

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.

Updated by Haru Iida almost 14 years ago Actions
Copy link
 #2

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

Updated by Haru Iida almost 14 years ago Actions
Copy link
 #3

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

Updated by Felix Sendino almost 14 years ago Actions
Copy link
 #4

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

Actions
Copy link

Also available in: PDF Atom