Bug 1758548 - VMs search filter compatibility_level not applied on custom_compatibility_version
Summary: VMs search filter compatibility_level not applied on custom_compatibility_ver...
Keywords:
Status: CLOSED DUPLICATE of bug 1758565
Alias: None
Product: ovirt-engine
Classification: oVirt
Component: Frontend.WebAdmin
Version: future
Hardware: All
OS: All
unspecified
medium
Target Milestone: ---
: ---
Assignee: bugs@ovirt.org
QA Contact: meital avital
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2019-10-04 13:35 UTC by Antonio Romito
Modified: 2019-10-04 14:17 UTC (History)
1 user (show)

Fixed In Version:
Clone Of:
Environment:
Last Closed: 2019-10-04 14:17:41 UTC
oVirt Team: Virt
Embargoed:


Attachments (Terms of Use)

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 ***


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