Issue 117754 - form filtering with Date/Timestamp field for Oracle not possible
Summary: form filtering with Date/Timestamp field for Oracle not possible
Status: UNCONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: DEV300m105
Hardware: PC Windows XP
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-04-07 15:00 UTC by eberlein
Modified: 2013-01-29 22:01 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description eberlein 2011-04-07 15:00:08 UTC
To reproduce, connect a form containing a date field to Oracle via JDBC. The table must have a date or a timestamp field.
Start filtering with an expression like ">01/04/2011". Type Enter or Tab.
The field value changes to "> '01.04.2011'". Push the filter button.
No ResultSet.
IIRC this has worked in OpenOffice 2 (Expression did change to > #01.04.2011#).
So Regression?
Comment 1 Oliver-Rainer Wittmann 2012-06-13 12:27:15 UTC
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.