Bug 1398344 - Policy Event.Miq Policy Sets fields filter out all the records if those are used in Report's Filter
Summary: Policy Event.Miq Policy Sets fields filter out all the records if those are u...
Keywords:
Status: CLOSED DEFERRED
Alias: None
Product: Red Hat CloudForms Management Engine
Classification: Red Hat
Component: Reporting
Version: 5.6.0
Hardware: Unspecified
OS: Unspecified
medium
medium
Target Milestone: GA
: cfme-future
Assignee: Gregg Tanzillo
QA Contact: Ievgen Zapolskyi
URL:
Whiteboard: report
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2016-11-24 13:50 UTC by Ievgen Zapolskyi
Modified: 2018-08-15 13:55 UTC (History)
3 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-08-15 13:55:40 UTC
Category: Bug
Cloudforms Team: CFME Core
Target Upstream Version:


Attachments (Terms of Use)

Description Ievgen Zapolskyi 2016-11-24 13:50:06 UTC
Description of problem:
It seems Policy Event.Miq Policy Sets broken down.
F.e. There is report called "Policy Events for Last Week - Sample 2". 
I have policy events where "Miq Policy Set->Set Type" == 'MiqPolicySet'.
If I remove that report's filter rule, I'll see a list of Miq Policy fields for my policy events.
But If I add filter rule "Miq Policy Set->Set Type" contains 'MiqPolicySet', I'll receive empty report. 
This is true for any field of Miq Policy Set entity.


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

How reproducible:
100%

Steps to Reproduce:
1. Generate policy events using any way.
F.e.
1.1 Create Policy Profile + Policy + Condition + Events (Condition can check power state for instance)
1.2. Assign this profile to any vm
1.3. Power on/off the vm
1.4 make sure there are some policy events in policy_events table  
2. Go to Cloud Intel->Reports and select report All Reports->Events->Policy->"Policy Events for Last Week - Sample 2"
3. Add this report to queue and check its results when it is generated

Actual results:
the report didn't collect any data. The report will display expected data if filtering rule "Policy Event.Miq Policy Sets : Date Created" >= "7 Days Ago"
is removed

Expected results:
Information about Policy Sets should be displayed

Comment 4 Yuri Rudman 2018-08-15 13:55:40 UTC
Closing this BZ since 5.6 is in "Maintenance Support" phase.
Please check on latest released version and create another BZ if needed.


Note You need to log in before you can comment on or make changes to this bug.