Summary: | Query wizard in need of love | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Lionel Elie Mamane <lionel> |
Component: | Base | Assignee: | Omkar Nikam <omkar.nikam.2026> |
Status: | ASSIGNED --- | ||
Severity: | normal | CC: | heiko.tietze, himajin100000, iplaw67, lukasz.hryniuk, mentoring |
Priority: | medium | Keywords: | difficultyInteresting, easyHack, skillCpp, topicUI |
Version: | 4.2.0.0.alpha0+ Master | ||
Hardware: | All | ||
OS: | All | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=161144 | ||
Whiteboard: | reviewed:2023 | ||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | 56750, 59978 | ||
Bug Blocks: | 108443 |
Description
Lionel Elie Mamane
2013-08-02 10:41:15 UTC
adding LibreOffice developer list as CC to unresolved EasyHacks for better visibility. see e.g. http://nabble.documentfoundation.org/minutes-of-ESC-call-td4076214.html for details Adding self to CC if not already on Migrating Whiteboard tags to Keywords: (EasyHack DifficultyInteresting SkillCpp TopicUI) [NinjaEdit] JanI is default CC for Easy Hacks (Add Jan; remove LibreOffice Dev List from CC) [NinjaEdit] Please add keyword 'needsUXEval' and CC 'libreoffice-ux-advise@lists.freedesktop.org' if input from UX is needed. 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. |