Yaniv Dary has uploaded a new change for review. Change subject: reports: fixed return type on input control (#854926) ......................................................................
reports: fixed return type on input control (#854926) The query contained a case that return either date type or timestamp type, this caused the input control to ignore the user selection of dates. This was fixed by adding a cast. bug-url: https://bugzilla.redhat.com/854926 Change-Id: Id36fbe7ff9fec29de401faf0c7aaff823ce104a9 Signed-off-by: Yaniv Dary <[email protected]> --- M reports/repository_files/resources/reports_resources/JDBC/Input_Controls/Period_Affected/non-002dquery_IC/P_Start_Date.xml 1 file changed, 1 insertion(+), 1 deletion(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-reports refs/changes/63/8763/1 diff --git a/reports/repository_files/resources/reports_resources/JDBC/Input_Controls/Period_Affected/non-002dquery_IC/P_Start_Date.xml b/reports/repository_files/resources/reports_resources/JDBC/Input_Controls/Period_Affected/non-002dquery_IC/P_Start_Date.xml index 6f8eb3b..7b7fcf8 100644 --- a/reports/repository_files/resources/reports_resources/JDBC/Input_Controls/Period_Affected/non-002dquery_IC/P_Start_Date.xml +++ b/reports/repository_files/resources/reports_resources/JDBC/Input_Controls/Period_Affected/non-002dquery_IC/P_Start_Date.xml @@ -22,7 +22,7 @@ <language>sql</language> <queryString>SELECT DISTINCT CASE WHEN $P{P_Period} = 'Daily' THEN cast(o.the_date as date) - ELSE date_trunc('month', o.the_date) + ELSE cast(date_trunc('month', o.the_date) as date) END as active_months, CASE WHEN $P{P_Period} = 'Daily' THEN cast(cast(o.the_date as date) as varchar) -- To view, visit http://gerrit.ovirt.org/8763 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Id36fbe7ff9fec29de401faf0c7aaff823ce104a9 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-reports Gerrit-Branch: master Gerrit-Owner: Yaniv Dary <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
