Bug 1540698

Summary: Selecting filter with "expression Service: Aggregate All Vm Cpus" results in exception
Product: Red Hat CloudForms Management Engine Reporter: Satoe Imaishi <simaishi>
Component: APIAssignee: Nick LaMuro <nlamuro>
Status: CLOSED CURRENTRELEASE QA Contact: Matouš Mojžíš <mmojzis>
Severity: high Docs Contact:
Priority: high    
Version: 5.9.0CC: cpelland, hkataria, lavenel, mmojzis, mpovolny, obarenbo, simaishi
Target Milestone: GA   
Target Release: 5.9.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard: ui:filter
Fixed In Version: 5.9.0.20 Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: 1539710 Environment:
Last Closed: 2018-03-06 15:27:58 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: CFME Core Target Upstream Version:
Embargoed:
Bug Depends On: 1539710    
Bug Blocks:    

Comment 2 CFME Bot 2018-01-31 19:52:39 UTC 
New commit detected on ManageIQ/manageiq/gaprindashvili:
https://github.com/ManageIQ/manageiq/commit/01a01787c8c75d76ebf2d6f84d0b6ffdb9678021

commit 01a01787c8c75d76ebf2d6f84d0b6ffdb9678021
Author:     Gregg Tanzillo <gtanzill>
AuthorDate: Wed Jan 31 10:24:37 2018 -0500
Commit:     Satoe Imaishi <simaishi>
CommitDate: Wed Jan 31 14:44:51 2018 -0500

    Merge pull request #16915 from NickLaMuro/bz-1539710-quick-fix-avoid-service-agg-col-with-miq-exp
    
    Exclude Service::AGGREGATE_ALL_VM_ATTRS from MiqExp.to_sql
    (cherry picked from commit 57095386dfb0fe1d799a1ad7bfc6fef6278dac98)
    
    https://bugzilla.redhat.com/show_bug.cgi?id=1540698

 lib/miq_expression.rb | 14 +++++++++-----
 1 file changed, 9 insertions(+), 5 deletions(-)
Comment 3 Matouš Mojžíš 2018-02-07 13:19:20 UTC 
Verified in 5.9.0.20. I added this filter and applied it with no issues.