Shirly Radco has uploaded a new change for review. Change subject: reports: changed br44 delete_date condition ......................................................................
reports: changed br44 delete_date condition Changed the report query delete_date condition. Change-Id: Ibd6e91bc7642946d575ab1d6bd01e2d8d148975d Signed-off-by: Shirly Radco <[email protected]> --- M packaging/ovirt-reports/resources/Reports/Inventory/ccp_vm_inventory_br44_files/ccp_vm_inventory_br44_jrxml.data 1 file changed, 2 insertions(+), 16 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-reports refs/changes/03/28003/1 diff --git a/packaging/ovirt-reports/resources/Reports/Inventory/ccp_vm_inventory_br44_files/ccp_vm_inventory_br44_jrxml.data b/packaging/ovirt-reports/resources/Reports/Inventory/ccp_vm_inventory_br44_files/ccp_vm_inventory_br44_jrxml.data index b37ff9c..1a555a1 100644 --- a/packaging/ovirt-reports/resources/Reports/Inventory/ccp_vm_inventory_br44_files/ccp_vm_inventory_br44_jrxml.data +++ b/packaging/ovirt-reports/resources/Reports/Inventory/ccp_vm_inventory_br44_files/ccp_vm_inventory_br44_jrxml.data @@ -223,22 +223,8 @@ WHEN $P{P_Period} = 3 THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 year' END - AND ( - ( - v3_5_configuration_history_vms.delete_date < - CASE - WHEN $P{P_Period} = 0 - THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 day' - WHEN $P{P_Period} = 1 - THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 month' - WHEN $P{P_Period} = 2 - THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '3 month' - WHEN $P{P_Period} = 3 - THEN CAST ( $P{P_Start_Date} AS TIMESTAMP ) + interval '1 year' - END - AND v3_5_configuration_history_vms.delete_date >= - CAST( $P{P_Start_Date} AS TIMESTAMP ) - ) + AND v3_5_configuration_history_vms.delete_date > + CAST( $P{P_Start_Date} AS TIMESTAMP ) OR v3_5_configuration_history_vms.delete_date IS NULL ) -- To view, visit http://gerrit.ovirt.org/28003 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ibd6e91bc7642946d575ab1d6bd01e2d8d148975d Gerrit-PatchSet: 1 Gerrit-Project: ovirt-reports Gerrit-Branch: master Gerrit-Owner: Shirly Radco <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
