Bug 1109740

Summary: sorting compute resources and subnets tables by different keys produces ISE
Product: Red Hat Satellite Reporter: Jan Hutař <jhutar>
Component: WebUIAssignee: Ohad Levy <ohadlevy>
Status: CLOSED CURRENTRELEASE QA Contact: Katello QA List <katello-qa-list>
Severity: low Docs Contact:
Priority: unspecified    
Version: NightlyCC: bkearney, dcleal, jmontleo, mkorbel, stbenjam
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
URL: http://projects.theforeman.org/issues/6234
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-09-11 12:29:20 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Jan Hutař 2014-06-16 09:48:33 UTC
Description of problem:
Sorting different tables by different keys produces ISE


Version-Release number of selected component (if applicable):
Satellite-6.0.3-RHEL-6-20140612.1


How reproducible:
always


Steps to Reproduce:
1. Go to Compute Resources page:
     Infrastructure -> Compute Resources
2. Attempt to sort by "Type" (click on "Type" in table heading)

OR:

1. Go to Subnets page:
     Infrastructure -> Subnets
2. Attempt to sort by "Domain" (click on "Domain" in table heading)


Actual results:
Error appears


Expected results:
Should be sorted by given column


Additional info:
Sorting compute resources by Type:

Processing by ComputeResourcesController#index as HTML
  Parameters: {"order"=>"type ASC"}
Operation FAILED: the field 'type' in the order statement is not valid field for search
  Rendered common/500.html.erb within layouts/application (4.4ms)
  Rendered layouts/base.html.erb (1.1ms)
Completed 500 Internal Server Error in 22ms (Views: 7.1ms | ActiveRecord: 0.0ms)

Sorting subnets by Domain:

Processing by SubnetsController#index as HTML
  Parameters: {"order"=>"domains ASC"}
Operation FAILED: the field 'domains' in the order statement is not valid field for search
  Rendered common/500.html.erb within layouts/application (7.1ms)
  Rendered layouts/base.html.erb (1.5ms)
Completed 500 Internal Server Error in 28ms (Views: 11.1ms | ActiveRecord: 0.0ms)

Comment 2 Dominic Cleal 2014-06-16 09:50:18 UTC
Created redmine issue http://projects.theforeman.org/issues/6234 from this bug

Comment 4 Bryan Kearney 2014-06-17 14:05:24 UTC
Moving to POST since upstream bug http://projects.theforeman.org/issues/6234 has been closed

Comment 6 Bryan Kearney 2014-07-11 14:03:07 UTC
Moving to POST since upstream bug http://projects.theforeman.org/issues/6234 has been closed
-------------
Dominic Cleal
https://github.com/theforeman/foreman/pull/1517
-------------
Stephen Benjamin
Applied in changeset commit:5dd996fd87a191e1dd4cf07d20a90ed4145fdf50.

Comment 9 Martin Korbel 2014-09-01 10:02:51 UTC
VERIFIED on Satellite-6.0.4-RHEL-6-20140827.0 (foreman-1.6.0.42-1.el6sat)

Comment 10 Bryan Kearney 2014-09-11 12:29:20 UTC
This was delivered with Satellite 6.0 which was released on 10 September 2014.