This plugins allows a redmine user to run SQL queries inside redmine's wiki pages.

Installation

Follow the default redmine plugin installation steps at http://www.redmine.org/projects/redmine/wiki/Plugins

Usage:

Put this inside a wiki page: {{sql( *Your Query* )}}

Example:

{{sql(select id as 'ID', subject as 'Subject', DATE_FORMAT\(issues.due_date , '%d/%m/%Y'\) AS 'Due Date' from issues)}}

Known problems:

- User has to manually escape parenthesis with \

Bug Fixes:

- Can't change column's order [SOLVED]