Feature #5098
open
Custom SQL Queries
0%
Description
Hi everyone,
Redmine's query interface is great, but sometimes there are queries that aren't possible using just the query builder. It would be cool if one had the option of either using the query builder or typing in SQL manually. The custom query would have to return only the set of issue IDs, which Redmine could then use to fetch all additional information it needs to properly display the result set in the usual way.
It would probably be possible to support the regular query builder on top of the custom query. For example, the custom query is used internally to create a view, and then the query builder is applied to the view, rather than the issues table.
Just a thought. It would certainly add a lot of flexibility for power-users, and they wouldn't have to constantly pester you for specific filter-related features.
Related issues
Updated by
Updated by Chris Magowan over 13 years ago
that ould be great!
i have just implemented redmine in my project, but relaised that we cannot easily make custom reports. for instance, we would like a report that brings up all calls that were closed in teh past month. currently this is not possible (as far as i can see!).
Updated by Alan Trick over 13 years ago
I've written a plugin that provides this functionality. It's not great but it works: https://github.com/alantrick/redmine_sql_reports
Updated by Dietrich Streifert almost 13 years ago
Alan Trick wrote:
I've written a plugin that provides this functionality. It's not great but it works: https://github.com/alantrick/redmine_sql_reports
Hi Alan! Any hints on how to use the plugin? I've failed with a simple sql query with the error message "wrong number of arguments (1 for 2)".
Updated by txemi M about 12 years ago
+1
I would love this plugin in mainstream.
I frequently need queries that cannot be done from UI.
Updated by Go MAEDA 10 months ago
- Has duplicate Feature #21783: Custom reports from SQL query added
Updated by Go MAEDA 10 months ago
- Related to Feature #27875: SQL custom query added
Updated by Go MAEDA 10 months ago
- Category changed from Search engine to Issues
I think Redmine should not include this feature because allowing SQL execution may lead to security issues. For example, a user might be able to view any issues using SQL, even if they do not have permission to see those issues in Redmine.