[Libreoffice-bugs] [Bug 118817] FIREBIRD: EXTRACT Function - WEEK, WEEKDAY and YEARDAY
https://bugs.documentfoundation.org/show_bug.cgi?id=118817 Vilos changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- 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
[Libreoffice-bugs] [Bug 118817] FIREBIRD: EXTRACT Function - WEEK, WEEKDAY and YEARDAY
https://bugs.documentfoundation.org/show_bug.cgi?id=118817 --- Comment #7 from Vilos --- Created attachment 143721 --> https://bugs.documentfoundation.org/attachment.cgi?id=143721=edit Design View for WEEKDAY and YEARDAY error and LO Version Tools - Options - Advanced - Enable experimental features set. WEEK works. WEEKDAY and YEARDAY don't. See attached image. Just to re-iterate, the SQL equivalent statements work in Tools->SQL. -- 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
[Libreoffice-bugs] [Bug 118817] FIREBIRD: EXTRACT Function - WEEK, WEEKDAY and YEARDAY
https://bugs.documentfoundation.org/show_bug.cgi?id=118817 --- Comment #6 from Drew Jensen --- Created attachment 143720 --> https://bugs.documentfoundation.org/attachment.cgi?id=143720=edit Querydesigner screen shot Simple case is working for me on Ubuntu 18.04 and build (QueryDesigner Screenshot) Version: 6.1.1.0.0+ Build ID: 2466ea26c4bef1e002a24f6845084633e5a058c4 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:libreoffice-6-1, Time: 2018-07-21_22:43:36 Locale: en-US (en_US.UTF-8); Calc: group threaded and 6.2 Master -- 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
[Libreoffice-bugs] [Bug 118817] FIREBIRD: EXTRACT Function - WEEK, WEEKDAY and YEARDAY
https://bugs.documentfoundation.org/show_bug.cgi?id=118817 Xisco Faulí changed: What|Removed |Added Status|NEW |NEEDINFO CC||xiscofa...@libreoffice.org --- Comment #5 from Xisco Faulí --- (In reply to Vilos from comment #3) > Hi. It was reported as fixed in that build, but it isn't for fixed for me. I > texted it again in RC2. Still not working. Interestingly, I can no longer > create a FIREBIRD db in RC2. You need to enable the experimental features first. Tools - Options - Advanced - Enable experimental features.. I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version. -- 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
[Libreoffice-bugs] [Bug 118817] FIREBIRD: EXTRACT Function - WEEK, WEEKDAY and YEARDAY
https://bugs.documentfoundation.org/show_bug.cgi?id=118817 --- Comment #4 from Vilos --- Just to add, that you may be pointing out that I should've replied to that previous thread. Didn't find it - sorry1 -- 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
[Libreoffice-bugs] [Bug 118817] FIREBIRD: EXTRACT Function - WEEK, WEEKDAY and YEARDAY
https://bugs.documentfoundation.org/show_bug.cgi?id=118817 --- Comment #3 from Vilos --- Hi. It was reported as fixed in that build, but it isn't for fixed for me. I texted it again in RC2. Still not working. Interestingly, I can no longer create a FIREBIRD db in RC2. -- 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
[Libreoffice-bugs] [Bug 118817] FIREBIRD: EXTRACT Function - WEEK, WEEKDAY and YEARDAY
https://bugs.documentfoundation.org/show_bug.cgi?id=118817 Julien Nabet changed: What|Removed |Added CC||serval2...@yahoo.fr See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=10 ||4986 --- Comment #2 from Julien Nabet --- Dup of tdf#104986? -- 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
[Libreoffice-bugs] [Bug 118817] FIREBIRD: EXTRACT Function - WEEK, WEEKDAY and YEARDAY
https://bugs.documentfoundation.org/show_bug.cgi?id=118817
Drew Jensen 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 ---
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
