https://issues.apache.org/ooo/show_bug.cgi?id=121492
--- Comment #8 from hanya <[email protected]> --- 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.
