Summary: | Report Builder edit of Data Filter results in bad SQL syntax. | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | JD <jdm212> |
Component: | Database | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED WORKSFORME | QA Contact: | |
Severity: | critical | ||
Priority: | medium | CC: | robert |
Version: | 3.5.5.3 release | ||
Hardware: | x86 (IA32) | ||
OS: | All | ||
See Also: | https://bugs.freedesktop.org/show_bug.cgi?id=52127 | ||
Whiteboard: | |||
i915 platform: | i915 features: |
Description
JD
2012-07-14 19:36:34 UTC
I have tested it under OpenSuSE 11.4. In LO 3.3.4 it works. You could change the values with the filter-wizard during editing a report. The produced code is correct. In LO 3.5.5 you could only change the code directly. The dialog produces wrong code. Then I tested the dialog in tables. The dialog for filters didn't work under LO 3.5.5 here. Have changed the Status to "New" and the Platform to "All". Will report another bug for the filter-dialog in tables. Have just tested it once more. The date in the filter changes in LO 3.5.7.2, when reopening a filter in the Report-Builder to a syntax error in SQL. When I open it with LO 3.6.6.2 the filter could be edited and is saved in the right way. I will close this bug as Resolved and Worksforme. Feel free to reopen, when the bug also appears in newer versions of LO. Concur - Seems to be ok in 4.1.0.4 Slight oddity in that if the previous "bad" syntax had been saved in the report filter, it needs to be deleted before an edit can happen. No problem there really. |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.