Bug 1758548

Summary: VMs search filter compatibility_level not applied on custom_compatibility_version
Product: [oVirt] ovirt-engine Reporter: Antonio Romito <aromito>
Component: Frontend.WebAdminAssignee: bugs <bugs>
Status: CLOSED DUPLICATE QA Contact: meital avital <mavital>
Severity: medium Docs Contact:
Priority: unspecified    
Version: futureCC: bugs
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: All   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2019-10-04 14:17:41 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: Virt RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

Description Antonio Romito 2019-10-04 13:35:38 UTC
Description of problem:

From the Engine Web GUI filtering function in:
Compute --> Virtual Machines --> Vms: compatibility_level 
return the "vms.cluster_compatibility_version" instead of "vms.custom_compatibility_version"

Query performed on the database is:

~~~
:
...method: getAllUsingQuery, params: [SELECT * FROM ((SELECT  vms.* FROM  vms   WHERE  vms.cluster_compatibility_version ILIKE '4.1' )  ORDER BY vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]...
:
~~~

It should be:

~~~
SELECT * FROM ((SELECT  vms.* FROM  vms   WHERE  vms.custom_compatibility_version ILIKE '4.1' 
~~~

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

RHV 4.2 (4.2.7.4)

How reproducible:

Try to apply a filter on "Compute --> Virtual Machines --> Vms: compatibility_level = "<custom_compatibility_version>". where VMs have minor compatibility version compared to the cluster compatibility version.


Steps to Reproduce:
1.Login to RHV
2.Select 'Compute' --> 'Virtual Machines'
3.Type in filter textbox -- >compatibility_level = "<custom_compatibility_version>"

Actual results:

Currently even if there are VMs with a custom_compatibility_version these are not returned when filter is applied  

Expected results:

When a filter on a given custom_compatibility_version is applied the search should return the VMs with that custom_compatibility_version


Additional info:

Comment 1 Antonio Romito 2019-10-04 14:17:41 UTC

*** This bug has been marked as a duplicate of bug 1758565 ***