Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 574594

Summary:	Sorting by date not working as expected on Users page
Product:	Red Hat Satellite 5	Reporter:	Xixi <xdmoon>
Component:	Server	Assignee:	Partha Aji <paji>
Status:	CLOSED ERRATA	QA Contact:	Garik Khachikyan <gkhachik>
Severity:	medium	Docs Contact:
Priority:	medium
Version:	530	CC:	cperry, gkhachik, mkoci, paji, tao, xdmoon
Target Milestone:	---
Target Release:	---
Hardware:	All
OS:	Linux
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2010-06-22 14:05:19 UTC	Type:	---
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:	518256

Description Xixi 2010-03-17 21:58:28 UTC

Description of problem:
Under Users tab - the list of users - sorting the list by "Last Sign in" isn't working as expected. The sort is not done as per date but looks an ascii sort.

Version-Release number of selected component (if applicable):
Red Hat Network (RHN) Satellite 5.3.0

System architecture(s):
RHEL 5 U3 i386 platform

How reproducible:
Always.

Steps to Reproduce:
1. Have a satellite with at least 3 users with different sign in months (like 2, 12, 3).
2. Login to Satellite -> Users -> Click on "Last Sign In"

Actual results:
It is not sorted by date but sorted as a normal sort [string]

Expected results:
Sorted by date.

Additional info:
This is similar to bug 508771

Comment 1 Partha Aji 2010-03-31 21:58:30 UTC

I saw similar bugs occur in Deactivated List, All, Active and Confirm Reactivate pages.. Where the "Last Sign In" and Changed Dates was using string based Sort. All have been changed to Date as of
http://git.fedorahosted.org/git/spacewalk.git/?p=spacewalk.git;a=commit;h=b813e7d5ebf4118fb5742108db0c9f2c17f67aa7

Comment 5 Garik Khachikyan 2010-06-07 16:03:53 UTC

# VERIFIED

Checked against RHEL4, RHEL5 installed satellites (in i386, x86_64 archs) - the issue is corrected now.

Comment 7 errata-xmlrpc 2010-06-22 14:05:19 UTC

An advisory has been issued which should help the problem
described in this bug report. This report is therefore being
closed with a resolution of ERRATA. For more information
on therefore solution and/or where to find the updated files,
please follow the link below. You may reopen this bug report
if the solution does not work for you.

http://rhn.redhat.com/errata/RHBA-2010-0498.html