Bug 1541109

Summary:	Wrong search result, when trying to filter for particular compliance policy
Product:	Red Hat Satellite	Reporter:	Suraj Patil <supatil>
Component:	Search	Assignee:	Ondřej Pražák <oprazak>
Status:	CLOSED ERRATA	QA Contact:	Peter Ondrejka <pondrejk>
Severity:	high	Docs Contact:
Priority:	high
Version:	6.3.0	CC:	akarsale, bkearney, kgaikwad, marjones, mhulan, pcreech, satellite6-bugs
Target Milestone:	6.4.0	Keywords:	Triaged
Target Release:	Unused
Hardware:	x86_64
OS:	Linux
Whiteboard:
Fixed In Version:	foreman_openscap-0.10.1	Doc Type:	If docs needed, set a value
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2018-10-16 19:05:54 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 Suraj Patil 2018-02-01 17:38:00 UTC

Description of problem:
Getting wrong search result, when trying to filter for particular compliance_policy in Satellite WebUI > Hosts > Reports

Version-Release number of selected component (if applicable):
Satellite 6.3.0

How reproducible:
Make sure there are more than one arf reports from different compliance policies.

Steps to Reproduce:
1. Go to satellite webui > Hosts > Reports
2. In search filter put " compliance_policy = anything"
3. It results showing all the reports.

Also the API call return all the reports.

Example -

curl -X GET -s -k -u admin:redhat https://vm253-190.gsslab.pnq2.redhat.com/api/v2/compliance/arf_reports?search="compliance_policy=xyz" | python -m json.tool

Actual results:
Returns all the arf reports.

Expected results:
Sorted reports according to the search filter.

Also tested this on satellite 6.2.12 and found the same results

Comment 1 Marek Hulan 2018-02-02 08:02:59 UTC

Created redmine issue http://projects.theforeman.org/issues/22491 from this bug

Comment 2 Marek Hulan 2018-02-02 08:04:18 UTC

reproducible in nightly upstream

Comment 10 Satellite Program 2018-06-12 16:04:55 UTC

Upstream bug assigned to oprazak

Comment 11 Satellite Program 2018-06-12 16:04:59 UTC

Upstream bug assigned to oprazak

Comment 13 Satellite Program 2018-06-15 14:05:08 UTC

Moving this bug to POST for triage into Satellite 6 since the upstream issue http://projects.theforeman.org/issues/22491 has been resolved.

Comment 14 Peter Ondrejka 2018-07-23 14:57:01 UTC

Verified on Satellite 6.4 snap 13, compliance reports search works as expected in the UI

Comment 15 Bryan Kearney 2018-10-16 19:05:54 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-2018:2927