https://bugs.documentfoundation.org/show_bug.cgi?id=96370
--- Comment #4 from [email protected] --- Filter creates something like this: SELECT "date", SUM( "int" ) "total" FROM "table" WHERE SUM( "int" ) = 44 GROUP BY "date" This query won't work in internal HSQLDB. Workaround: Switch from the query to a view. The GUI will create a query, which doesn't notice anything about sum("int") or GROUP BY "date". Don't know why it works different when filter is set in the query directly. But this filter has also problems and could only be resetted by deleting the filter. But the behavior in queries is better than showing nothing in a form. The buggy behavior is the same in every LO-version I have installed here (SUSE 42.1, 64bit rpm Linux, LO 3.6, 4.1 ...) -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
