Project

General

Profile

Bug #2933

Query Builder comparisons for strings, dates do not work

Added by Dan Higgins almost 12 years ago. Updated over 11 years ago.

Status:
Resolved
Priority:
Immediate
Assignee:
Category:
data access
Target version:
Start date:
09/04/2007
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2933

Description

Attempt to filter data sets using QueryBuilder apparently do not work for strings (or date?). Note that date in Datos dataset appears as a String. Is there a Date object? Numerical comparison filter apparently DO work

History

#1 Updated by Jing Tao over 11 years ago

After changing the double quotes symbol to single quotes for string value in the query, the string comparison works now.

There is some difficulties to use Date and Time data types in HSQL. HSQL can only handle one format for Date and Time -
Date: yyyy-mm-dd
Time: hh:ss.SSSS

Other formats will be considered as error in HSQL. However, eml documents have lots of other formats and they can't be handle by HSQL.

We may transform the date format to the one, which HSQL can understand, in data file by java. However, in this case, kepler modifies the original data file, which is not our target.

#2 Updated by Matt Jones over 11 years ago

Although the transformation to the HSQL date format is a change, its probably going to be necessary for many systems. In many ways it is similar to how the DataManager library does name-mangling to deal with database-specific limitations in naming. As long as you are not losing or changing information, I think the transformation to the right date format for insert into the database is a good idea.

#3 Updated by Jing Tao over 11 years ago

Dan tried to string comparison and it works for him. We talked this bug and think to close it in Kepler and add new bug in datamanager - to handle date type.

#4 Updated by Jing Tao over 11 years ago

This bug is closed and new bug to handle date type in data manager library will be added.

#5 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 2933

Also available in: Atom PDF