Project

General

Profile

Actions

Feature #5098

open

Custom SQL Queries

Added by Pascal Schoenhardt about 14 years ago. Updated 3 months ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Issues
Target version:
-
Start date:
2010-03-16
Due date:
% Done:

0%

Estimated time:
Resolution:

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

Related to Redmine - Feature #27875: SQL custom queryClosed

Actions
Has duplicate Redmine - Feature #21783: Custom reports from SQL queryClosed

Actions
Actions

Also available in: Atom PDF