Bug 1017798

Summary: installed sort order processed alphabetically instead of chronologically
Product: Red Hat Satellite 5 Reporter: Charles Slivkoff <caslivkoff>
Component: WebUIAssignee: Tomas Lestach <tlestach>
Status: CLOSED EOL QA Contact: Red Hat Satellite QA List <satqe-list>
Severity: low Docs Contact:
Priority: unspecified    
Version: 541CC: cperry, tkasparek
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-07-09 13:48:01 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:
Bug Depends On:    
Bug Blocks: 462714    

Description Charles Slivkoff 2013-10-10 14:16:20 UTC 
Description of problem:

When selecting to sort the RPM package list for a system, the installation dates are processed alphabetically. It would be expected for the sort order bo be chronological.
 
Version-Release number of selected component (if applicable):

5.4.1

How reproducible:

Always.

Steps to Reproduce:
1. Select a system.
2. Select "Software"
3. Select "Packages"
4. Select "List/Remove"
5. Select "Installed"

Actual results:

Installation dates are sorted alphabetically (either ascending or decending).


Expected results:

Installation order should be presented chronologically.


Workaround:

On the client, use "rpm -qa --queryformat" to display the date, then post-process that to convert the unix timestamp to a user-preferred format.

rpm -qa --queryformat "%{INSTALLTIME} %{NAME}\n"  | sort -n | awk '{print strftime("%Y-%m-%dT%H:%M:%S",$1),$2;}'
Comment 1 Tomas Lestach 2015-07-09 13:48:01 UTC 
This has been fixed in upstream back in 2011. See Bug 722453 for more details.
The fix is available in Satellite 5.5 and newer. As Satellite 5.4 was EOLed, I'm closing this BZ.