Bug 1187657

Summary: Sorting on Errata id does not work on errata page
Product: Red Hat Satellite Reporter: sthirugn <sthirugn>
Component: WebUIAssignee: Walden Raines <walden>
WebUI sub component: Katello QA Contact: sthirugn <sthirugn>
Status: CLOSED ERRATA Docs Contact:
Severity: medium    
Priority: unspecified CC: bkearney
Version: Nightly   
Target Milestone: Unspecified   
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
URL: http://projects.theforeman.org/issues/9181
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-08-12 05:22:59 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:
Bug Depends On:    
Bug Blocks: 1130651, 1188301    

Description sthirugn@redhat.com 2015-01-30 15:30:52 UTC 
Description of problem:
Sorting does not work on errata page

Version-Release number of selected component (if applicable):
* apr-util-ldap-1.3.9-3.el6_0.1.x86_64
* candlepin-0.9.38-1.el6.noarch
* candlepin-common-1.0.18-1.el6.noarch
* candlepin-selinux-0.9.38-1.el6.noarch
* candlepin-tomcat6-0.9.38-1.el6.noarch
* elasticsearch-0.90.10-7.el6.noarch
* foreman-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch
* foreman-compute-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch
* foreman-gce-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch
* foreman-libvirt-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch
* foreman-ovirt-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch
* foreman-postgresql-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch
* foreman-proxy-1.8.0-0.develop.201501280951gite1bc928.el6.noarch
* foreman-release-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch
* foreman-selinux-1.8.0-0.develop.201412151103gite2863e4.el6.noarch
* foreman-vmware-1.8.0-0.develop.201501290916git1f0e9bd.el6.noarch
* katello-2.1.0-1.201411061509gitb0b8f43.el6.noarch
* katello-certs-tools-2.0.1-1.el6.noarch
* katello-default-ca-1.0-1.noarch
* katello-installer-2.2.0-1.201501272021gitf707d62.el6.noarch
* katello-installer-base-2.2.0-1.201501272021gitf707d62.el6.noarch
* katello-repos-2.1.1-1.el6.noarch
* katello-server-ca-1.0-1.noarch
* openldap-2.4.39-8.el6.x86_64
* openldap-devel-2.4.39-8.el6.x86_64
* pulp-docker-plugins-0.2.1-0.2.beta.el6.noarch
* pulp-katello-0.3-3.el6.noarch
* pulp-nodes-common-2.5.1-1.el6.noarch
* pulp-nodes-parent-2.5.1-1.el6.noarch
* pulp-puppet-plugins-2.5.1-1.el6.noarch
* pulp-puppet-tools-2.5.1-1.el6.noarch
* pulp-rpm-plugins-2.5.1-1.el6.noarch
* pulp-selinux-2.5.1-1.el6.noarch
* pulp-server-2.5.1-1.el6.noarch
* python-ldap-2.3.10-1.el6.x86_64
* ruby193-rubygem-ldap_fluff-0.3.3-1.el6.noarch
* ruby193-rubygem-net-ldap-0.10.0-1.el6.noarch
* ruby193-rubygem-runcible-1.3.0-1.el6.noarch

How reproducible:
Always

Steps to Reproduce:
1.Navigate to Content -> Errata.
2.Attempt to sort the errata in UI by clicking on the column names - Errata ID, Title, Type, Content Host Counts, Updated

Actual results:
- Sorting does not work on Title, Type, Content Host Counts, Updated
- I was able to click on Errata ID but the page went on loading and never finished

Expected results:
Sorting should work on Errata Id, Title, Type, Content Host Counts, Updated fields as per http://projects.theforeman.org/issues/7905

Additional info:
Comment 2 Walden Raines 2015-01-30 20:41:57 UTC 
The feature mentioned in this bug has not yet been implemented.  The bug fix here is thus limited to fixing the issue when sorting by Errata ID:

PG::UndefinedColumn: ERROR:  column katello_errata.errataid does not exist
Comment 3 Walden Raines 2015-01-30 20:44:12 UTC 
Created redmine issue http://projects.theforeman.org/issues/9181 from this bug
Comment 4 Bryan Kearney 2015-02-03 17:04:51 UTC 
Moving to POST since upstream bug http://projects.theforeman.org/issues/9181 has been closed
-------------
Walden Raines
Applied in changeset commit:katello|5c7b8974d751a542ab40b24b6c7ffa81ee9cd510.
Comment 7 sthirugn@redhat.com 2015-02-13 22:01:10 UTC 
Verified as per Comment 2.

Version Tested:
Satellite-6.1.0-RHEL-6-20150210.0
Comment 8 Bryan Kearney 2015-08-11 13:31:04 UTC 
This bug is slated to be released with Satellite 6.1.
Comment 9 errata-xmlrpc 2015-08-12 05:22:59 UTC 
Since the problem described in this bug report should be
resolved in a recent advisory, it has been closed with a
resolution of ERRATA.

For information on the advisory, and where to find the updated
files, follow the link below.

If the solution does not work for you, open a new bug report.

https://access.redhat.com/errata/RHSA-2015:1592