diff options
author | Fabrice Bellingard <bellingard@gmail.com> | 2011-05-26 14:31:00 +0200 |
---|---|---|
committer | Fabrice Bellingard <bellingard@gmail.com> | 2011-05-26 14:31:00 +0200 |
commit | 68abaf902d32166f637242d04187cdd5dfc62d81 (patch) | |
tree | 6da69458f98cad39d5ac6c4ed8b5591f6a6e9716 | |
parent | f769fb5f2e558c027c92b87c5ad989913793d224 (diff) | |
download | sonarqube-68abaf902d32166f637242d04187cdd5dfc62d81.tar.gz sonarqube-68abaf902d32166f637242d04187cdd5dfc62d81.zip |
SONAR-2397 Remove sort on Assignee and Project
The reason is that the DB request fails on Derby because of the joint
needed to get the assignee name or the project name.
FI: it worked on Postgres (and probably all other "real" DBs).
-rw-r--r-- | sonar-server/src/main/webapp/WEB-INF/app/models/review.rb | 1 | ||||
-rw-r--r-- | sonar-server/src/main/webapp/WEB-INF/app/views/reviews/index.html.erb | 10 |
2 files changed, 2 insertions, 9 deletions
diff --git a/sonar-server/src/main/webapp/WEB-INF/app/models/review.rb b/sonar-server/src/main/webapp/WEB-INF/app/models/review.rb index 3951dc0edaf..8789ad1a020 100644 --- a/sonar-server/src/main/webapp/WEB-INF/app/models/review.rb +++ b/sonar-server/src/main/webapp/WEB-INF/app/models/review.rb @@ -184,7 +184,6 @@ class Review < ActiveRecord::Base sort = 'reviews.updated_at DESC' end - # We define 'assignee' before 'user' in the ':include' so that it is possible to sort on the assignee.name Review.find(:all, :include => [ 'review_comments', 'project', 'assignee', 'resource', 'user' ], :conditions => [conditions.join(' AND '), values], :order => sort, :limit => 200) end diff --git a/sonar-server/src/main/webapp/WEB-INF/app/views/reviews/index.html.erb b/sonar-server/src/main/webapp/WEB-INF/app/views/reviews/index.html.erb index 0ea652fc444..0b1d521a583 100644 --- a/sonar-server/src/main/webapp/WEB-INF/app/views/reviews/index.html.erb +++ b/sonar-server/src/main/webapp/WEB-INF/app/views/reviews/index.html.erb @@ -112,14 +112,8 @@ function launchSearch(columnName, link) { <a href="#" onClick="launchSearch('title', this)">Title</a> <%= image_tag(@asc ? "asc12.png" : "desc12.png") if @sort == 'title' -%> </th> - <th width="1%"> - <a href="#" onClick="launchSearch('projects.name', this)">Project</a> - <%= image_tag(@asc ? "asc12.png" : "desc12.png") if @sort == 'projects.name' -%> - </th> - <th> - <a href="#" onClick="launchSearch('users.name', this)">Assignee</a> - <%= image_tag(@asc ? "asc12.png" : "desc12.png") if @sort == 'users.name' -%> - </th> + <th width="1%">Project</th> + <th>Assignee</th> <th> <a href="#" onClick="launchSearch('updated_at', this)">Age</a> <%= image_tag(@asc ? "asc12.png" : "desc12.png") if @sort == 'updated_at' -%> |