Bug 1215756

Summary: Searching an errata with issued date displays incorrect results
Product: Red Hat Satellite Reporter: sthirugn <sthirugn>
Component: Content ManagementAssignee: Walden Raines <walden>
Status: CLOSED CURRENTRELEASE QA Contact: sthirugn <sthirugn>
Severity: high Docs Contact:
Priority: unspecified    
Version: 6.1.0CC: bbuckingham, bkearney, jnikolak
Target Milestone: UnspecifiedKeywords: Triaged
Target Release: Unused   
Hardware: Unspecified   
OS: Unspecified   
URL: http://projects.theforeman.org/issues/10383
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-08-12 13:57:52 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:
Attachments:
Description Flags
Incorrect errata display
none
Verification screenshot none

Description sthirugn@redhat.com 2015-04-27 16:30:07 UTC
Created attachment 1019378 [details]
Incorrect errata display

Description of problem:
Searching an errata with issued date displays incorrect results

Version-Release number of selected component (if applicable):
Satellite-6.1.0-RHEL-6-20150424.0

How reproducible:
Always

Steps to Reproduce:
1. Navigate to Web UI -> Content -> Errata Tab (or)
Navigate to Hosts -> Content Hosts -> Select a Content host -> Errata Tab
2. Search for issued = "Apr 21, 2015"

Actual results:
The search returned erratas with issued date of "Apr 20, 2015" (see screenshot).

This same behavior is observed for all errata.  Search always returns (searchdate - 1 day)

Expected results:
Issued date matching the given search date should be returned

Additional info:

Comment 2 Walden Raines 2015-05-05 17:44:20 UTC
Created redmine issue http://projects.theforeman.org/issues/10383 from this bug

Comment 3 Walden Raines 2015-05-05 18:59:26 UTC
PR - https://github.com/Katello/katello/pull/5204

Note that the fix for this bug requires a database migration.  Not sure our policy for that from beta to GA.

Comment 4 Bryan Kearney 2015-05-07 16:06:01 UTC
Moving to POST since upstream bug http://projects.theforeman.org/issues/10383 has been closed
-------------
Walden Raines
Applied in changeset commit:katello|e44c303adf35789077b9d15148c9c423cfdf46d0.

Comment 7 sthirugn@redhat.com 2015-05-14 15:12:39 UTC
Verified.

Version Tested:
GA Snap 4 Compose 2

Verification screenshot attached.

Comment 8 sthirugn@redhat.com 2015-05-14 15:13:27 UTC
Created attachment 1025464 [details]
Verification screenshot

Comment 9 Bryan Kearney 2015-08-11 13:32:17 UTC
This bug is slated to be released with Satellite 6.1.

Comment 10 Bryan Kearney 2015-08-12 13:57:52 UTC
This bug was fixed in version 6.1.1 of Satellite which was released on 12 August, 2015.

Comment 11 Chris Peters 2016-03-29 17:23:34 UTC
*** Bug 1250760 has been marked as a duplicate of this bug. ***