Yaniv Dary has posted comments on this change. Change subject: reports: br21 report - added comments to queries ......................................................................
Patch Set 6: (2 comments) http://gerrit.ovirt.org/#/c/25136/6/packaging/ovirt-reports/resources/Reports/Inventory/Storage_Domain_Report_BR21_files/Storage_Domain_Report_BR21_jrxml.data File packaging/ovirt-reports/resources/Reports/Inventory/Storage_Domain_Report_BR21_files/Storage_Domain_Report_BR21_jrxml.data: Line 73: THEN NULL Line 74: ELSE CAST ( $P{P_StorageDomain_ID} AS uuid ) Line 75: END Line 76: AND history_datetime >= CAST ( $P{P_Start_Date} AS timestamp ) Line 77: AND history_datetime <= '=' in both. Line 78: CASE Line 79: WHEN $P{P_Period} = 0 Line 80: THEN CAST ( $P{P_Start_Date} AS timestamp ) + interval '1 day' Line 81: WHEN $P{P_Period} = 1 Line 100: a.history_datetime = b.$P!{calendar_column} Line 101: ) Line 102: WHERE Line 103: $P!{calendar_column} >= CAST ( $P{P_Start_Date} AS date ) Line 104: AND $P!{calendar_column} <= same Line 105: CASE Line 106: WHEN $P{P_Period} = 0 Line 107: THEN CAST ( $P{P_Start_Date} AS timestamp ) + interval '1 day' Line 108: WHEN $P{P_Period} = 1 -- To view, visit http://gerrit.ovirt.org/25136 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: I6011ea7812ab7abdf5367da5f61c44a8bc2d6d3c Gerrit-PatchSet: 6 Gerrit-Project: ovirt-reports Gerrit-Branch: master Gerrit-Owner: Shirly Radco <[email protected]> Gerrit-Reviewer: Shirly Radco <[email protected]> Gerrit-Reviewer: Yaniv Dary <[email protected]> Gerrit-Reviewer: [email protected] Gerrit-HasComments: Yes _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
