To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116608 Issue #|116608 Summary|Base table data view: Filters are cleared/reset when a | filter set results in no matches. and must be re-ente |red. Component|Database access Version|OOO320m18 Platform|PC URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|none Assigned to|dbaneedsconfirm Reported by|mandamus
------- Additional comments from manda...@openoffice.org Tue Jan 25 16:19:38 +0000 2011 ------- 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. Example: 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. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@dba.openoffice.org For additional commands, e-mail: issues-h...@dba.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org