https://bugs.documentfoundation.org/show_bug.cgi?id=139315
Robert Großkopf <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #8 from Robert Großkopf <[email protected]> ---
The default value has nothing to do with this behavior.
The query could only be executed by direct SQL, because the GUI doesn't know
what to do with '- 365'. Remember: DATEADD (and this is a part of it) isn't
known in the old internal HSQLDB.
So the Report Builder doesn't know how to handle with this query. You also have
to set the report builder to
Analyze SQL → No
for executing a query, which doesn't work with the Query GUI.
This query will work:
SELECT * FROM "EMP" WHERE WHERE "startdate" > CAST( CURRENT_DATE AS DATE ) -
365
I don't know why, but the GUI will accept this and it will also work together
with report builder and format the date directly as a date.
One hint: Report Builder will better work with views. He could analyze the SQL,
all grouping and sorting will work. The view looks for the report like a table
with clear defined types for every field.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
