https://bugs.documentfoundation.org/show_bug.cgi?id=118817
Drew Jensen <drewjensen.in...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
OS|Windows (All) |All
CC| |drewjensen.in...@gmail.com
Ever confirmed|0 |1
--- Comment #1 from Drew Jensen <drewjensen.in...@gmail.com> ---
Confirmed in today's build of 6.1 RC and 6.2Alpha0
The extract function will work without SQL Direct enabled but is not recognized
in the designer UI.
For example:
1 Download this example file
https://nextcloud.documentfoundation.org/s/ePAmqMj3N2Ywms4
2 Create a new query with the SQL view and enter the following Select
statement.
SELECT "Country",
COALESCE("FirstName", ' ', "LastName") As "Name",
EXTRACT(YEAR FROM "OrderDate") As "Year",
COUNT(*) As "Count"
FROM "Employees" INNER JOIN "Orders"
ON ("Employees"."EmployeeID"="Orders"."EmployeeID")
GROUP BY "Country", "Name", "Year"
3 Run the query (zero records because one of the tables is empty)
4 switch views to the designer UI
5 Unable to run the query or even switch back to SQL view.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
