Shirly Radco has uploaded a new change for review.
Change subject: reports: br10b report - fixed query
......................................................................
reports: br10b report - fixed query
Fixed the condition on delete_date to include
the vms that were deleted after the start_date.
Change-Id: I5fd679b87e7376ab2b27a9a53c6ffac52d429656
Signed-off-by: Shirly Radco <sra...@redhat.com>
---
M
packaging/ovirt-reports/resources/Reports/Trend/Virtual_machines/single_vm_resources_days_week_BR10B_files/single_vm_resources_days_week_BR10B_jrxml.data
1 file changed, 2 insertions(+), 2 deletions(-)
git pull ssh://gerrit.ovirt.org:29418/ovirt-reports refs/changes/94/27494/1
diff --git
a/packaging/ovirt-reports/resources/Reports/Trend/Virtual_machines/single_vm_resources_days_week_BR10B_files/single_vm_resources_days_week_BR10B_jrxml.data
b/packaging/ovirt-reports/resources/Reports/Trend/Virtual_machines/single_vm_resources_days_week_BR10B_files/single_vm_resources_days_week_BR10B_jrxml.data
index 4c3ec08..bd92f17 100644
---
a/packaging/ovirt-reports/resources/Reports/Trend/Virtual_machines/single_vm_resources_days_week_BR10B_files/single_vm_resources_days_week_BR10B_jrxml.data
+++
b/packaging/ovirt-reports/resources/Reports/Trend/Virtual_machines/single_vm_resources_days_week_BR10B_files/single_vm_resources_days_week_BR10B_jrxml.data
@@ -280,7 +280,7 @@
THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) +
interval '1 year'
END
AND (
- delete_date <= CAST ( $P{P_Start_Date} AS TIMESTAMP )
+ delete_date > CAST ( $P{P_Start_Date} AS TIMESTAMP )
OR
delete_date IS NULL
)
@@ -511,7 +511,7 @@
THEN CAST ( $P{P_Start_Date} AS TIMESTAMP
) + interval '1 year'
END
AND (
- delete_date <= CAST ( $P{P_Start_Date} as
TIMESTAMP )
+ delete_date > CAST ( $P{P_Start_Date} as TIMESTAMP
)
OR
delete_date IS NULL
)
--
To view, visit http://gerrit.ovirt.org/27494
To unsubscribe, visit http://gerrit.ovirt.org/settings
Gerrit-MessageType: newchange
Gerrit-Change-Id: I5fd679b87e7376ab2b27a9a53c6ffac52d429656
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-reports
Gerrit-Branch: master
Gerrit-Owner: Shirly Radco <sra...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches
