Bug 91775 - Case when not working in ver 4.4 of libre base
Summary: Case when not working in ver 4.4 of libre base
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-05-31 15:01 UTC by Dave
Modified: 2015-10-11 13:17 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Dave 2015-05-31 15:01:54 UTC
Ver 4.4 or latest vers. does not seem to work when the CASE WHEN is nested in a between function

The idea is to open a parameter box asking for two dates, "start" and "end" dates, but should default to previously set start and (end dates ( Current_date)) if nothing is entered.

SqL is; WHERE "TransDate,D" BETWEEN CASE WHEN :DateFrom = '' THEN ( "default start date" ) ELSE TO_DATE( :DateFrom, 'MM/DD/YY' ) END AND CASE WHEN :DateTo = '' THEN CURRENT_DATE ELSE TO_DATE( :DateTo, 'MM/DD/YY' ) END

This works fine in Vers 4.2.8.2 and below. But not in latest version. The Parameter Query Box does show up asking for the start (datefrom)and end dates (Dateto) but, You must manually enter the dates in the latest version of base and the default dates do not work.

The default dates , the "case when" part does not work in latest version of Base.

Using W7pro hsqldb 2.3 in server mode( Multi user)

Any help or suggestion would be greatly appreciated
Comment 1 MM 2015-05-31 15:06:42 UTC
Can you attach a test file and/or steps to reproduce, so ppl can test your problem ?!
Comment 2 Joel Madero 2015-06-01 02:20:25 UTC
We need a test file - setting to NEEDINFO. Once you attach a simple test case please set to UNCONFIRMED. Thanks!
Comment 3 Julien Nabet 2015-10-11 13:17:52 UTC
No feedback since 4 months, let's put this to WFM.

Dave: don't hesitate to reopen this tracker when you'll be able to provide information asked in previous comments.