<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - GUI Form Properties:Data:Filter - needs () AND (), not ( AND )"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132620">132620</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>GUI Form Properties:Data:Filter - needs () AND (), not ( AND )
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.3.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>x86 (IA32)
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Base
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>trowelandmattock@yahoo.co.uk
</td>
</tr></table>
<p>
<div>
<pre>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 !!!</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>