https://bugs.documentfoundation.org/show_bug.cgi?id=134049
Robert Großkopf <rob...@familiegrosskopf.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|6.0.7.3 release |Inherited From OOo
Ever confirmed|0 |1
Status|UNCONFIRMED |NEW
CC| |rob...@familiegrosskopf.de
--- Comment #7 from Robert Großkopf <rob...@familiegrosskopf.de> ---
This is a feature request.
The GUI couldn't create such a code. It creates a code like
SELECT * FROM "Table1"
WHERE "FieldA" = :AskA AND "FieldB" = :AskB
OR "FieldA" = :AskA AND "FieldB" = IS NULL
OR "FieldA" IS NULL AND "FieldB" = :AskB
OR "FieldA" IS NULL AND "FieldB" = IS NULL
With this code nearly the whole possible rows for criteria in the designer will
be blocked. Adding a third field will be impossible in the designer.
SELECT * FROM "Table1"
WHERE ( "FieldA" = :AskA OR "FieldA" IS NULL) AND
("FieldB" = :AskB OR "FieldB" IS NULL )
This all works well without the GUI. The query doesn't need to be switched to
direct SQL. You could input data ...
I could confirm the behavior of the GUI. Would be a good idea to let the user
decide if he wants to set the columns of the query-GUI in brackets. At this
moment the GUI looks first for the rows, adds all content with "AND" and then
adds the next row with "OR".
This behavior exists since the beginning of LO, so I set the version to
"Inherited from OOo"
--
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
