[Bug 121492] Base can not filter by dates

[bu...@apache.org]

https://issues.apache.org/ooo/show_bug.cgi?id=121492

--- Comment #8 from hanya <ha...@gmail.com> ---
Thank you for the explanation.

When the filter is used in the table view, new SQL statement having WHERE
clause 
constructed in dbaui::DlgFilterCrit::BuildWherePart method.
getCondition method construct correct value for Date type field like:
{D'2000/01/01'}.
Then the constructed criteria is passed to
css.sdb.XSingleSelectQueryComposer::setStructuredFilter method. 
The passed argument is parsed in lcl_getCondition of SingleSelectQueryComposer
imple. 
These instance of PropertyValues contains their field name as
"TABLE_NAME"."FIELD_NAME", 
so the column can not be found to get correct data type of the field. 
If column is not found, parse::OParseColumn provides wrong data type, VARCHAR
is chosen 
and single quotes are escaped with ''.

The candidate to fix is: 
to make the column found in lcl_getCondition function that helps to get 
correct type of the field from Type property.

-- 
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.