[Libreoffice-bugs] [Bug 139315] report wizard displays date field as number in some cases

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=139315

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |robert at familiegrosskopf.de

--- Comment #8 from Robert Großkopf <robert at familiegrosskopf.de> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20201230/9680583a/attachment.htm>