GitHub - javatunix/redmine_wiki_sql: Redmine plugin that allows you to run SQL queries and have them shown on your wiki in table format

javatunix / redmine_wiki_sql Public

forked from rorx/redmine_wiki_sql

Notifications You must be signed in to change notification settings
Fork 0
Star 0

Redmine plugin that allows you to run SQL queries and have them shown on your wiki in table format

rodrigoramalho.com/redmine-wiki-sql-plugin/

0 stars 13 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 2 Commits
README		README
init.rb		init.rb

Repository files navigation

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:

- Can't change column's order
- User has to manually escape parenthesis with \