Issue 116608

Summary: Base table data view: Filters are cleared/reset when a filter set results in no matches. and must be re-entered.
Product: Base Reporter: mandamus <alacritous>
Component: codeAssignee: AOO issues mailing list <issues>
Status: UNCONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOO320m18   
Target Milestone: ---   
Hardware: PC   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description mandamus 2011-01-25 16:19:38 UTC
When using the filter in table data view in base, when you apply filters which 
result in 0 items matching the criteria, the filter values are cleared, making 
you start over. 
As long as SOME data matches the filter criteria then you can click on the 
filter icon and modify your filter rules. Unless your filter rules result in 
nothing returned. Then the filter icon is greyed and the filter set can no 
longer be modified. It must be cleared and you have to start over again. Which 
is very frustrating when you've built a complex filter set and have to start 
from scratch when the results are empty. 


fieldname foo = 45
And fieldname bar = "monkey"
Then click ok.

if this results in a match, you can click the filter icon again and modify the 
filter set and carry on. 

for example:

fieldname foo = 45
And fieldname bar = "monk%"
Then click ok.

but. if, for example, there's a typo or for whatever reason no data is returned 
such as from the following. 

fieldname foo = 45
And fieldname bar = "mynkey"
Then click okay

The filter icon is greyed, and the only way to carry on is to clear the filter 
and add your filters again.
Comment 1 r4zoli 2011-01-27 07:57:28 UTC
Please check in OOo 3.3, it works for me in OOo 3.3 on win7.
I can modify filter criteria if results is empty.