summaryrefslogtreecommitdiffstats
path: root/app/models/query.rb
Commit message (Collapse)AuthorAgeFilesLines
...
* Allow issue grouping by custom field (#2679).Jean-Philippe Lang2009-11-161-0/+11
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@3071 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: case sensitivity in issue subject filtering (#3536).Jean-Philippe Lang2009-06-281-2/+2
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2796 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Changed Enumerations to use a Single Table InheritanceEric Davis2009-05-301-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | * Added migrations to change Enumerations to an STI relationship * Added TimeEntryActivity model (STI) * Added DocumentCategory model (STI) * Added IssuePriority model (STI) * Added Enumeration#get_subclasses to get a list of the subclasses of Enumeration * Changed Enumeration to use the STI type field instead of the opt field * Changed Enumeration#opt to return the old opt values but with a deprecation warning. * Removed Enumeration::OPTIONS * Removed the dynamic named_scopes in favor of specific named_scopes. Kept for compatibility reasons. * Added Enumeration#default so each subclass can easily find it's default record. * Fixed Enumeration#default to use the STI scoping with a fake default scope for finding Enumeration's default. * Added a 'all' named scope for getting all records in order by position. * Added Deprecation warnings to the old named_scopes in Enumerations. * Moved various methods off of Enumeration and onto the concrete classes * Changed the EnumerationsController to use types * Updated the Enumeration list template * Added has_many relationships to the Enumeration STI classes. * Fixes for tests. #3007 git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2777 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Ability to use any custom field as a cross-project custom query column (#3321).Jean-Philippe Lang2009-05-131-1/+1
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2743 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Ticket grouping (#2679).Jean-Philippe Lang2009-04-261-9/+33
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2696 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixing bug #3009, trivial updates of localesAzamat Hackimov2009-03-221-2/+2
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2614 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Ability to save "sort order" in custom queries (#2899).Jean-Philippe Lang2009-03-121-0/+27
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2572 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds a sortable "Project" column to the issue list.Jean-Philippe Lang2009-03-071-1/+5
| | | | | | It's displayed by default on the cross-project issue list (#2889). It's also available for saved queries. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2566 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Merged Rails 2.2 branch. Redmine now requires Rails 2.2.2.Jean-Philippe Lang2009-02-211-4/+2
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2493 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds ability to filter watched issues (#846).Jean-Philippe Lang2009-02-121-15/+22
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2456 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Include both version date and name when sorting issues by target version ↵Jean-Philippe Lang2009-02-011-1/+1
| | | | | | (#1502). git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2352 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Include both last and first name when sorting issues by assignee (#1841).Jean-Philippe Lang2009-02-011-1/+1
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2351 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Merged nested projects branch. Removes limit on subproject nesting (#594).Jean-Philippe Lang2009-01-241-5/+5
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2304 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Ability to sort the issue list by text, list, date and boolean custom fields ↵Jean-Philippe Lang2009-01-111-1/+1
| | | | | | (#1139). git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2257 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Final refactoring on Query#sql_for_field to rename v to valueEric Davis2008-12-051-14/+14
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2092 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Bit more refactoring on Query#sql_for_field to remove multiple returnsEric Davis2008-12-051-18/+18
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2091 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Refactor: Extracted new method Query#sql_for_field from Query#statement inEric Davis2008-12-051-45/+54
| | | | | | | order to clean up Query#statement. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2090 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed date filters accuracy with SQLite (#2221).Jean-Philippe Lang2008-11-231-7/+19
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@2054 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: cross-project issue list should not show issues of projects for which ↵Jean-Philippe Lang2008-09-251-1/+1
| | | | | | the issue tracking module was disabled. git-svn-id: http://redmine.rubyforge.org/svn/trunk@1907 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds support for free ticket filtering and custom queries on Calendar.Jean-Philippe Lang2008-09-111-9/+11
| | | | | | ProjectsController#calendar moved to IssuesController. git-svn-id: http://redmine.rubyforge.org/svn/trunk@1798 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds estimated hours to issue filters (#1678).Jean-Philippe Lang2008-07-261-2/+3
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@1696 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Custom fields refactoring: most of code moved from controllers to models ↵Jean-Philippe Lang2008-06-271-2/+2
| | | | | | (using new module ActsAsCustomizable). git-svn-id: http://redmine.rubyforge.org/svn/trunk@1592 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Add filters on cross-project issue list for custom fields marked as 'For all ↵Jean-Philippe Lang2008-06-221-19/+30
| | | | | | projects'. git-svn-id: http://redmine.rubyforge.org/svn/trunk@1576 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Hide 'Target version' filter if no version is defined.Jean-Philippe Lang2008-06-221-1/+3
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@1575 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Prevents NoMethodError on @available_filters.has_key? in query.rb (#1178).Jean-Philippe Lang2008-05-251-1/+1
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@1454 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: private subprojects are listed on the issues view (#1217).Jean-Philippe Lang2008-05-141-10/+7
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@1432 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: Search for target version of "none" fails with postgres 8.3 (#1134).Jean-Philippe Lang2008-04-291-4/+8
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@1379 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixes custom field filters behaviour (#1078).Jean-Philippe Lang2008-04-261-3/+3
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@1362 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Queries can be marked as 'For all projects'. Such queries will be available ↵Jean-Philippe Lang2008-03-301-2/+9
| | | | | | | | | on all projects and on the global issue list (#897, closes #671). Only admin users can create/edit queries that are public and for all projects. Note: this change does not allow to save a query from the global issue list. You have to be inside a project but then you can mark the query as 'For all projects'. git-svn-id: http://redmine.rubyforge.org/svn/trunk@1311 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: Priorities not ordered when displayed as a filter in issue list (#956).Jean-Philippe Lang2008-03-301-1/+1
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@1309 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: 'This week' condition in filter consider monday as the first day of ↵Jean-Philippe Lang2008-03-231-1/+6
| | | | | | the week even if language sets otherwise (closes #913). git-svn-id: http://redmine.rubyforge.org/svn/trunk@1291 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Allow issue list to be sorted by target version (#832).Jean-Philippe Lang2008-03-161-1/+1
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@1264 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds an application setting to choose whether or not subprojects issues ↵Jean-Philippe Lang2008-03-061-6/+13
| | | | | | should be displayed by default on the issue list, calendar and gantt (r1178). Default is true. git-svn-id: http://redmine.rubyforge.org/svn/trunk@1198 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Include subprojects on the issue list, calendar and gantt by default.Jean-Philippe Lang2008-02-281-9/+11
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@1178 e93f8b46-1217-0410-a6f0-8f06a7374b81
* More appropriate default sort order on sortable columns.Jean-Philippe Lang2008-02-051-5/+6
| | | | | | Sortable column added on issue subject (#580). git-svn-id: http://redmine.rubyforge.org/svn/trunk@1121 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Add 'Author' to the available columns for the issue list.Jean-Philippe Lang2008-02-031-0/+1
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@1110 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: Incorrect filtering for unset values when using 'is not' filter.Jean-Philippe Lang2008-01-231-1/+1
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@1098 e93f8b46-1217-0410-a6f0-8f06a7374b81
* On the calendar, the gantt and in the Tracker filter on the issue list, only ↵Jean-Philippe Lang2008-01-161-1/+4
| | | | | | active trackers of the project (and its sub projects) can be selected. git-svn-id: http://redmine.rubyforge.org/svn/trunk@1071 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: issue queries can not use custom fields marked as 'for all projects' ↵Jean-Philippe Lang2008-01-151-1/+1
| | | | | | in a project context. git-svn-id: http://redmine.rubyforge.org/svn/trunk@1067 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fix query management broken by r1027.Jean-Philippe Lang2007-12-311-1/+1
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@1031 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: 'assigned to me' filter broken.Jean-Philippe Lang2007-12-121-8/+6
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@979 e93f8b46-1217-0410-a6f0-8f06a7374b81
* 'Assigned to' drop down list is now sorted by user's lastname.Jean-Philippe Lang2007-12-011-1/+1
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@939 e93f8b46-1217-0410-a6f0-8f06a7374b81
* * Fixed: Error when displaying the issue list if a float custom field is ↵Jean-Philippe Lang2007-11-211-2/+2
| | | | | | | | | marked as 'used as filter' * Fixed: Mercurial adapter breaks on missing :files entry in changeset hash (James Britt) * Fixed: Wrong feed URLs on the home page git-svn-id: http://redmine.rubyforge.org/svn/trunk@921 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Anonymous users can now be allowed to create, edit, comment issues, comment ↵Jean-Philippe Lang2007-11-201-5/+2
| | | | | | | | news and post messages in the forums. These permissions need to be explicitly given to the Anonymous role (Admin -> Roles & Permissions -> Anonymous). git-svn-id: http://redmine.rubyforge.org/svn/trunk@919 e93f8b46-1217-0410-a6f0-8f06a7374b81
* 'fixed version' field can now be displayed on the issue list.Jean-Philippe Lang2007-11-181-0/+1
| | | | | | Category and fixed version fields added to the CSV export. git-svn-id: http://redmine.rubyforge.org/svn/trunk@914 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: localization problem on issue list headers.Jean-Philippe Lang2007-11-161-0/+1
| | | | | | Updated Russian translation (iGor kMeta). git-svn-id: http://redmine.rubyforge.org/svn/trunk@906 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Custom fields can now be displayed as columns on the issue list.Jean-Philippe Lang2007-11-071-2/+27
| | | | | | | Custom fields marked as "for all projects" can be added to the default columns of the issue list (in application settings). Project specific custom fields can be displayed on custom queries. git-svn-id: http://redmine.rubyforge.org/svn/trunk@889 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: <<me>> doesn't appear in the drop down filters on a project issue list.Jean-Philippe Lang2007-11-051-1/+1
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@885 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Issues sorted by priority position.Jean-Philippe Lang2007-10-041-1/+1
| | | | git-svn-id: http://redmine.rubyforge.org/svn/trunk@801 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Default columns displayed on the issue list can now be selected at ↵Jean-Philippe Lang2007-10-011-9/+8
| | | | | | | | application level. Saved queries can overide this selection. git-svn-id: http://redmine.rubyforge.org/svn/trunk@785 e93f8b46-1217-0410-a6f0-8f06a7374b81