https://bugs.documentfoundation.org/show_bug.cgi?id=67664
Hossein <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Summary|query wizard in need of |Query wizard in need of |love |love Whiteboard| |reviewed:2023 --- Comment #6 from Hossein <[email protected]> --- Re-evaluating the EasyHack in 2023 This issue is still relevant. Most of the above mentioned problems still persist. Problem 1: SQLQueryComposer class → 💔 Java SQLQueryComposer class is defined in wizards/com/sun/star/wizards/db/SQLQueryComposer.java. It has not been touched in the last 7 years: https://git.libreoffice.org/core/+log/6f6a31d3e3b2ff113d5cc3a1ea960059cf09ceae/wizards/com/sun/star/wizards/db/SQLQueryComposer.java Problem 2: Confused columns with same name in different tables: → 💔 The table name is used in the wizard itself, but not in the final output. So this is still an issue. Problem 3: Confused aliasing results: → 💔 Still an issue. Problem 4: Confused aggregation result names: → 💔 Still an issue. Problem 5 and 6: Confusing result of the group by/having: → 💔 This is still confusing and not so useful. -- You are receiving this mail because: You are the assignee for the bug.
