This service will be undergoing maintenance at 00:00 UTC, 2017-10-23 It is expected to last about 30 minutes

Bug 615314

Summary: Complex search for DOWN resource returning UP resources
Product: [Other] RHQ Project Reporter: John Sanda <jsanda>
Component: SearchBarAssignee: Charles Crouch <ccrouch>
Status: CLOSED CURRENTRELEASE QA Contact: Mike Foley <mfoley>
Severity: high Docs Contact:
Priority: high    
Version: 3.0.0CC: hbrock, jshaughn
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2014-06-04 15:53:32 EDT Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: ---

Description John Sanda 2010-07-16 09:49:47 EDT
Description of problem:
When I run the following search,

availability=down (plugin=platform | plugin=RHQAGENT | plugin=Apache)

it returns UP resources. The generated JPQL is,

SELECT resource
FROM Resource resource
WHERE ( resource.inventoryStatus = :inventoryStatus )
AND  (  (  ( resource.currentAvailability.availabilityType = 0 )  AND  ( LOWER( LIKE '%(plugin=platform%' )  )  OR  ( LOWER(resource.resourceType.plugin) LIKE '%rhqagent%' )  OR  ( LOWER(resource.resourceType.plugin) LIKE '%apache%' )  )

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

How reproducible:

Steps to Reproduce:
Actual results:

Expected results:

Additional info: