Description of problem:
the Queries : "uptime < 1" or "uptime > 1" doesn't work.
Version-Release number of selected component (if applicable):
Red Hat Virtualization Manager Version: 184.108.40.206-0.1.el7
Steps to Reproduce:
1.Select Vms Tab in webadmin
2.Type & select from autocomplete "Vms:uptime> or <"
The search hangs forever (because bad SQL query)
Sun Jan 22 11:51:14 GMT+200 2017 org.ovirt.engine.ui.frontend.Frontend
WARNING: Failure while invoking runQuery [StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms.* FROM vms WHERE vms.elapsed_time < '86400' ) ORDER BY vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org.postgresql.util.PSQLException: ERROR: column vms.elapsed_time does not exist
Position: 58, StatementCallback; bad SQL grammar [SELECT * FROM ((SELECT distinct vms_* FROM vms WHERE vms_elapsed_time < '86400' ) ORDER BY vm_name ASC ) as T1 OFFSET (1 -1) LIMIT 100]; nested exception is org_postgresql_util_PSQLException: ERROR: column vms_elapsed_time does not exist
ugly SQL exception, should be fixed soon
This bug report has Keywords: Regression or TestBlocker.
Since no regressions or test blockers are allowed between releases, it is also being identified as a blocker for this release. Please resolve ASAP.
*** This bug has been marked as a duplicate of bug 1416837 ***