summaryrefslogtreecommitdiffstats
path: root/app/models/query.rb
Commit message (Collapse)AuthorAgeFilesLines
...
* Makes author column sortable and groupable on the issue list (#1567).Jean-Philippe Lang2011-11-191-1/+4
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@7843 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds a way to filter issues with or without start date (#9607).Jean-Philippe Lang2011-11-191-2/+2
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@7841 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Reverted r7628.Etienne Massip2011-10-181-6/+0
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@7629 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Filter out illegal values to prevent raise of PostgreSQL exceptions, ↵Etienne Massip2011-10-181-0/+6
| | | | | | restored last test part removed with r7625 (#8371). git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@7628 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed shot filter expression parsing depending upon field operators (#8371).Etienne Massip2011-10-121-3/+6
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@7624 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Rails3: model: query: parse dates using UTC (ruby 1.9 inside) (#4796)Toshi MARUYAMA2011-10-071-2/+5
| | | | | | | | | | | | | On Rails 3.0 and Ruby 1.8.7 in Japan (UTC+9), tests fails with following messages. test_operator_date_equals(QueryTest) [test/unit/query_test.rb:206]: <"(issues.due_date > '2011-07-09 14:59:59.999999' AND issues.due_date <= '2011-07-10 14:59:59.999999') AND (issue_statuses.is_closed='f')"> expected to be =~ </issues\.due_date > '2011-07-09 23:59:59(\.9+)?' AND issues\.due_date <= '2011-07-10 23:59:59(\.9+)?/>. Contributed by Sylvain Utard. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@7591 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Allow project column to be removed from the global issue list columns (#8411).Etienne Massip2011-09-261-9/+12
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@7538 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Rails3: replace deprecated 'validate' method at Query modelToshi MARUYAMA2011-09-201-1/+2
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@7425 e93f8b46-1217-0410-a6f0-8f06a7374b81
* remove trailing white-spaces from app/models/query.rb.Toshi MARUYAMA2011-08-201-17/+17
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6465 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Include issues asigned to user's groups when using "assigned to me" filter ↵Jean-Philippe Lang2011-07-311-1/+8
| | | | | | (#2964). git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6332 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: pagination do not show total visible issue count (#8633).Jean-Philippe Lang2011-07-241-1/+1
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6314 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Ability to assign issues to groups (#2964).Jean-Philippe Lang2011-07-231-6/+14
| | | | | | Option is disabled by default. It can be turned on in application settings. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6306 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Refactor: extract specific filter statements to methods.Jean-Philippe Lang2011-07-201-58/+63
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6301 e93f8b46-1217-0410-a6f0-8f06a7374b81
* More accurate date validation.Jean-Philippe Lang2011-07-111-1/+1
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6265 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Validate date filters values.Jean-Philippe Lang2011-07-111-0/+7
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6264 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Typo.Jean-Philippe Lang2011-07-111-1/+1
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6258 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixes "=" filter on float values.Jean-Philippe Lang2011-07-111-13/+25
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6256 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Keep invalid values and add validation error message.Jean-Philippe Lang2011-07-101-5/+5
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6229 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Reject non numeric values for numeric fields.Jean-Philippe Lang2011-07-101-1/+5
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6228 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixes filters on float values.Jean-Philippe Lang2011-07-101-6/+7
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6227 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds date based filters (#4729) and date range filter (#6954).Jean-Philippe Lang2011-07-101-31/+56
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6226 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds "between" operator for numeric filters (#6180).Jean-Philippe Lang2011-07-101-1/+14
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6217 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixes "less than", "greater than" filters on custom fields with postgres ↵Jean-Philippe Lang2011-07-091-2/+10
| | | | | | (#6180). git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6216 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Numeric operators for custom fields in query filters (#6180).Jean-Philippe Lang2011-07-091-0/+2
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6213 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Makes custom queries available through the REST API (#5737).Jean-Philippe Lang2011-07-061-1/+11
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6186 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: private queries should not be accessible to other users (#8729).Jean-Philippe Lang2011-07-031-0/+5
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@6163 e93f8b46-1217-0410-a6f0-8f06a7374b81
* remove trailing white-spaces from query model source.Toshi MARUYAMA2011-05-171-76/+76
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@5822 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Makes 'This week' filter work with any starting day of week (#7097).Jean-Philippe Lang2011-04-291-6/+4
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@5596 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Extract visibility condition from project statement and use visible scopes ↵Jean-Philippe Lang2011-04-121-7/+9
| | | | | | instead. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@5442 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Wrap text custom fields in the issue list (#8064).Jean-Philippe Lang2011-04-051-0/+8
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@5332 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Skip a few count(*) SQL queries on the issue list.Jean-Philippe Lang2011-04-021-6/+11
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@5292 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds User and Version custom field format that can be used to reference a ↵Jean-Philippe Lang2011-04-011-1/+4
| | | | | | | | project member or version in custom fields (#2096). These new field formats are available for project, issue, version and time entry custom fields. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@5272 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds Issue#visible_condition to build issue visibility statement.Jean-Philippe Lang2011-03-151-1/+1
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@5141 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: SQL error when filtering issues with an empty group or role (#7656).Jean-Philippe Lang2011-02-201-2/+12
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@4888 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: 500 error on issue query grouped by a custom field that was deleted ↵Jean-Philippe Lang2010-12-211-3/+3
| | | | | | (#7144). git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@4553 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Prevents n SQL queries (n = project count) on cross-project issues list.Jean-Philippe Lang2010-12-201-10/+12
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@4550 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: unchecking status filter on the issue list has no effect (#6844).Jean-Philippe Lang2010-11-071-2/+4
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@4387 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Remember the selected "Member of Role" and "Member of Group" options. #6467Eric Davis2010-10-161-2/+2
| | | | | | Contributed by Yuki Kita git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@4260 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Refactor: replace chained finders with an inject. Should handle edge cases ↵Eric Davis2010-09-101-3/+8
| | | | | | better. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@4079 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Added a "Member of Role" to the issues filters. #5869Eric Davis2010-09-101-0/+23
| | | | | | | This filter will check an issue's assigned to field for users who have (or don't have) a specific Role(s). git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@4078 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Added a "Member of Group" to the issues filter. #5869Eric Davis2010-09-101-0/+19
| | | | | | | This filter will check an issue's assigned to field for users in (or not in) specific groups. git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@4077 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Added project filter when viewing all issues. #5084Jean-Baptiste Barth2010-08-081-0/+6
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@3927 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: assigned_to and author filters in cross project issues view should be ↵Jean-Baptiste Barth2010-08-041-1/+1
| | | | | | based on user's project visibility. #5760 git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@3916 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adding missing setter for Query#available_columnsEric Davis2010-04-201-0/+8
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@3685 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Refactor: Move method to Query modelEric Davis2010-04-191-0/+7
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@3684 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Issue list improvements for subtasking (#5196):Jean-Philippe Lang2010-03-271-1/+3
| | | | | | | * makes the parent task column available * display the issue hierarchy when list is sorted by parent git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@3618 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Optimize retrieval of user's projects members.Jean-Philippe Lang2010-03-211-3/+5
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@3607 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Refactor: Extract Query#sortable_columns from the controller.Eric Davis2010-03-191-0/+8
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@3604 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds filter for system shared versions on the cross project issue list (#4792).Jean-Philippe Lang2010-02-101-0/+4
| | | | git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@3409 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed: issue summary counts should link to the issue list without ↵Jean-Philippe Lang2010-01-071-1/+1
| | | | | | subprojects (#4525). git-svn-id: svn+ssh://rubyforge.org/var/svn/redmine/trunk@3283 e93f8b46-1217-0410-a6f0-8f06a7374b81
generated by cgit v1.2.3 (git 2.39.1) at 2025-04-14 19:04:07 +0000