[Libreoffice-bugs] [Bug 134049] EDITING In the base query designer I would like to be able to request it to parse down the criterion of a column

[bugzilla-daemon at bugs.documentfoundation.org]

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

Robert Großkopf <robert at familiegrosskopf.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Version|6.0.7.3 release             |Inherited From OOo
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW
                 CC|                            |robert at familiegrosskopf.de

--- Comment #7 from Robert Großkopf <robert at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200708/3a0ebdcf/attachment.htm>