summaryrefslogtreecommitdiffstats
path: root/app/models/query.rb
Commit message (Collapse)AuthorAgeFilesLines
* Update copyright.Jean-Philippe Lang2017-06-251-1/+1
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@16685 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Show the same trackers and statuses on time entry queries (#5385).Jean-Philippe Lang2017-05-271-1/+1
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@16577 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Show statuses of project trackers only (#5385).Jean-Philippe Lang2017-05-271-0/+10
| | | | | | Patch by Marius BALTEANU. git-svn-id: http://svn.redmine.org/redmine/trunk@16575 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Query through multiple projects by issue custom field not possible anymore ↵Jean-Philippe Lang2017-04-031-0/+9
| | | | | | (#25501). git-svn-id: http://svn.redmine.org/redmine/trunk@16467 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fix link to issues when displaying a project query (#1565).Jean-Philippe Lang2017-03-151-12/+16
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@16409 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Let user choose columns and sort order of issue lists on "My page" (#1565).Jean-Philippe Lang2017-03-141-0/+16
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@16400 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Get rid of sort_helper when using queries.Jean-Philippe Lang2017-03-131-16/+28
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@16390 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Get the count by group from the query directly.Jean-Philippe Lang2017-03-091-0/+7
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@16387 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Issue description filter's 'none' operator does not match issues with blank ↵Jean-Philippe Lang2017-03-071-2/+2
| | | | | | | | descriptions (#25077). Patch by Marius BALTEANU. git-svn-id: http://svn.redmine.org/redmine/trunk@16378 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds updated_by and last_updated_by filters on issues (#17720).Jean-Philippe Lang2017-01-191-1/+1
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@16228 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Handle csv columns selection in query to preload appropriate associations ↵Jean-Philippe Lang2017-01-181-0/+3
| | | | | | (#24865). git-svn-id: http://svn.redmine.org/redmine/trunk@16219 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed that Query#has_column? returns false with default columns.Jean-Philippe Lang2017-01-171-1/+2
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@16217 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Moves sort joins for issues to IssueQuery.Jean-Philippe Lang2017-01-171-3/+0
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@16216 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Cast as decimal(30,0) instead of integer (#21249).Jean-Philippe Lang2017-01-141-2/+2
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@16197 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Filtering out specific subprojects (using 'is not' operator) (#15773).Jean-Philippe Lang2017-01-141-3/+10
| | | | | | Patch by Marius BALTEANU. git-svn-id: http://svn.redmine.org/redmine/trunk@16196 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Filters on chained custom fields and custom field attributes (#21249).Jean-Philippe Lang2017-01-141-1/+82
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@16191 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Don't preload custom field filter values (#24787).Jean-Philippe Lang2017-01-121-5/+0
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@16173 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Don't preload all query filters (#24787).Jean-Philippe Lang2017-01-091-10/+105
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@16170 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Set @available_filters as an empty hash if nil.Jean-Philippe Lang2016-10-201-0/+1
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15911 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Error with MS SQL when displaying an issue from a list grouped and sorted by ↵Jean-Philippe Lang2016-10-011-1/+1
| | | | | | fixed version (#23839). git-svn-id: http://svn.redmine.org/redmine/trunk@15852 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds issue tracker and status columns and filters on spent time list (#23401).Jean-Philippe Lang2016-08-201-0/+20
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15738 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Make time entries groupable (#16843).Jean-Philippe Lang2016-07-131-5/+9
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15649 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds a version filter on time entries (#13558).Jean-Philippe Lang2016-07-131-2/+2
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15646 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Remove special behaviour for listing issue time entries, use a filter for that.Jean-Philippe Lang2016-07-121-1/+1
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15644 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds scopes for retrieving the appropriate queries (#14790).Jean-Philippe Lang2016-07-121-0/+7
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15641 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Pull up query visibility methods.Jean-Philippe Lang2016-07-111-0/+63
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15636 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Makes QueriesController able to handle other Query subclasses.Jean-Philippe Lang2016-07-111-0/+2
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15635 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Limits the tracker list in filters and issue counts (#285).Jean-Philippe Lang2016-06-181-1/+1
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15540 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Code cleanup.Jean-Philippe Lang2016-05-161-1/+1
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15418 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Always return an array.Jean-Philippe Lang2016-05-161-4/+2
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15417 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Malformed SQL query with SQLServer when grouping and sorting by fixed ↵Jean-Philippe Lang2016-05-161-1/+1
| | | | | | version (#22808). git-svn-id: http://svn.redmine.org/redmine/trunk@15416 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixes Query#date_clause timezone handling (#22320).Jean-Philippe Lang2016-05-071-2/+10
| | | | | | | | | When querying time fields based on date values these should be interpreted in the user's time zone, since that's what a user usually expects. Patch by Jens Kraemer. git-svn-id: http://svn.redmine.org/redmine/trunk@15381 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Replace Date.today with User.current.today (#22320).Jean-Philippe Lang2016-05-071-7/+7
| | | | | | | | | | | | | | Depending on the offset between a user's configured timezone and the server timezone, Date.today may be more or less often wrong from the user's perspective, leading to things like issues marked as overdue too early or too late, or yesterday / tomorrow being displayed / selected where 'today' is intended. A test case illustrating the problem with Issue#overdue? is included Patch by Jens Kraemer. git-svn-id: http://svn.redmine.org/redmine/trunk@15379 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Filter by issue id (#4806).Jean-Philippe Lang2016-05-061-5/+10
| | | | | | A shortcut is added to the context menu to filter the selected issues. git-svn-id: http://svn.redmine.org/redmine/trunk@15371 e93f8b46-1217-0410-a6f0-8f06a7374b81
* SQL server: non ASCII filter on text fields does not work (#22405).Jean-Philippe Lang2016-04-241-2/+2
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15353 e93f8b46-1217-0410-a6f0-8f06a7374b81
* SQL server: non ASCII filter on issue subject does not work (#22405).Jean-Philippe Lang2016-04-241-2/+2
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15351 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Updates copyright for 2016.Jean-Philippe Lang2016-03-131-1/+1
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@15238 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Query project_statement - do not collect ids of subtree (#21611).Jean-Philippe Lang2016-01-301-5/+7
| | | | | | Patch by Ondřej Ezr. git-svn-id: http://svn.redmine.org/redmine/trunk@15135 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Moved custom fields totals logic to FieldFormat (#21413).Jean-Philippe Lang2015-12-051-16/+4
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@14944 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Ability to filter issues blocked by any/no open issues (#16621).Jean-Philippe Lang2015-11-071-3/+5
| | | | | | Patch by Arthur Andersen. git-svn-id: http://svn.redmine.org/redmine/trunk@14809 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Add users to assignee/author filters if they are missing (#3398).Jean-Philippe Lang2015-10-211-1/+8
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@14722 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixes float conversion failures (#1561).Jean-Philippe Lang2015-10-091-8/+10
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@14668 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Display totals for each group on grouped queries (#1561).Jean-Philippe Lang2015-10-091-3/+81
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@14665 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds options to display totals on the issue list (#1561).Jean-Philippe Lang2015-10-041-1/+40
| | | | | | Works for estimated hours, spent hours and any numeric custom field. git-svn-id: http://svn.redmine.org/redmine/trunk@14642 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Display all versions in query filter (#19271).Jean-Philippe Lang2015-09-261-1/+1
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@14623 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Query doesn't work with non ASCII uppercase symbols (#20438).Jean-Philippe Lang2015-08-021-2/+8
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@14476 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed that user with "Manage public queries" permission, can create global ↵Jean-Philippe Lang2015-06-291-1/+3
| | | | | | public query (#19842). git-svn-id: http://svn.redmine.org/redmine/trunk@14388 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Adds issue filters on parent/subtasks (#6118).Jean-Philippe Lang2015-06-131-1/+2
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@14304 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Don't call #upcase on nil.Jean-Philippe Lang2015-02-081-1/+1
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@13994 e93f8b46-1217-0410-a6f0-8f06a7374b81
* Fixed filtering on date custom field with SQLServer.Jean-Philippe Lang2015-02-081-25/+35
| | | | git-svn-id: http://svn.redmine.org/redmine/trunk@13993 e93f8b46-1217-0410-a6f0-8f06a7374b81