[Bug 67664] Query wizard in need of love

[bugzilla-daemon]

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

Omkar Nikam  changed:

   What|Removed |Added

   Assignee|libreoffice-b...@lists.free |omkar.nikam.2...@gmail.com
   |desktop.org |

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 67664] Query wizard in need of love

[bugzilla-daemon]

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

Hossein  changed:

   What|Removed |Added

Summary|query wizard in need of |Query wizard in need of
   |love|love
 Whiteboard||reviewed:2023

--- Comment #6 from Hossein  ---
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.

[Libreoffice-bugs] [Bug 67664] query wizard in need of love

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   Keywords||needsUXEval

-- 
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 67664] query wizard in need of love

[bugzilla-daemon]

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

jan iversen  changed:

   What|Removed |Added

 Whiteboard|ToBeReviewed|

-- 
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 67664] query wizard in need of love

[bugzilla-daemon]

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

jan iversen  changed:

   What|Removed |Added

 Whiteboard||ToBeReviewed

-- 
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 67664] query wizard in need of love

[bugzilla-daemon]

https://bugs.documentfoundation.org/show_bug.cgi?id=67664
Bug 67664 depends on bug 59978, which changed state.

Bug 59978 Summary: EDITING: Query-Wizard locale/date-format mixup
https://bugs.documentfoundation.org/show_bug.cgi?id=59978

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |WORKSFORME

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67664] query wizard in need of love

[bugzilla-daemon]

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

Björn Michaelsen  changed:

   What|Removed |Added

 Whiteboard|EasyHack|EasyHack
   |DifficultyInteresting   |DifficultyInteresting
   |SkillSQL SkillCpp   |SkillCpp TopicUI

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67664] query wizard in need of love

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=67664

--- Comment #2 from Alex Thurgood ipla...@yahoo.co.uk ---
Adding self to CC if not already on

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67664] query wizard in need of love

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=67664

Björn Michaelsen bjoern.michael...@canonical.com changed:

   What|Removed |Added

 CC||libreoffice@lists.freedeskt
   ||op.org

--- Comment #1 from Björn Michaelsen bjoern.michael...@canonical.com ---
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 67664] query wizard in need of love

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=67664

Lionel Elie Mamane lio...@mamane.lu changed:

   What|Removed |Added

 Whiteboard||EasyHack
   ||DifficultyInteresting
   ||SkillSQL SkillCpp

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs