Red Hat Bugzilla – Bug 689922
sorting on ancestry column throws exception
Last modified: 2011-05-23 21:15:39 EDT
Try to sort on ancestry column. You get:
Caused by: org.hibernate.QueryException: could not resolve property: resourceAncestry of: org.rhq.core.domain.resource.Resource [SELECT new org.rhq.core.domain.resource.composite.ResourceComposite( resource, resource.currentAvailability.availabilityType )
FROM org.rhq.core.domain.resource.Resource resource
WHERE ( resource.inventoryStatus = :inventoryStatus
AND resource.parentResource.id = :parentResourceId )
ORDER BY resource.resourceAncestry DESC
It would be nice if we were able to sort this column by on location in the hierarchy (peer resources are sorted alphanumerically). If we can't do that, turn off the ability to sort on that column.
i only see this in the Inventory tab of a recursive group.
to test - go to a group that is recursive, Inventory>Members tab and sort on the ancestry column and see that it doesn't bomb with an error message.
Verified on build#1175 (Version: 4.0.0-SNAPSHOT Build Number: a90faf9)
Created a recursive group and navigated to Inventory>Members tab of the group.
Clicking on ancestry column does not throw exception.
Also tried to sort on 'Ancestry' column in other parts of UI. It's working except in Reports->Configuration History tab. There is a separate bug filed for that (https://bugzilla.redhat.com/show_bug.cgi?id=697484).
Marking this bug as verified.
Bookkeeping - closing bug - fixed in recent release.