[Libreoffice-bugs] [Bug 132620] New: GUI Form Properties:Data:Filter - needs () AND (), not ( AND )

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 132620
           Summary: GUI Form Properties:Data:Filter - needs () AND (), not
                    (  AND  )
           Product: LibreOffice
           Version: 6.4.3.2 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Base
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: trowelandmattock at yahoo.co.uk

Using FIREBIRD embedded:(not confirmed with HSQL)

In the GUI Form Properties, Data:Filter tab , when setting a filter in a
subform using the GUI tool, and using more than 1 filter criteria, the output
is show as '(condition1 AND condition2)', i.e. when returning to the main Form
Properties, Data tab.

This returns no data when a Form is opened in normal mode.

The expected filter behavior is restored when the Form  Properties, Data:Filter
text box is manually amended to (condition1) AND (condition2)

Either (_AND_) or (_)AND(_) is fine by me, but it would be good if the GUI tool
produced the right result for the filter to function as expected, or at least
some notification for user to check and amend if necessary, for example under
different embedded engines.

Otherwise, as always -
Love You Libre !!!

-- 
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/20200502/1e60c3b7/attachment-0001.htm>