Apache OpenOffice (AOO) Bugzilla – Issue 13548
Paramater Name Substition Fails after two concurrent (form based) filters that yield zero results
Last modified: 2006-05-31 14:29:06 UTC
Set-up: A form (e.g. name & address) with a sub-form linked via Parameter Name Substitution (e.g. lookup of country code to verbose description). How to reproduce: Apply a form-based filter that will generate zero results (e.g. SURNAME LIKE '123*'). Apply another form-based filter and type over the existing one (e.g. SURNAME LIKE '456*'). If you change this filter for a third one that will work (e.g. SURNAME LIKE 'SMITH*') the sub-form results will not appear. Other notes: Applying the filter only once to get zero results and then one that does works fine (i.e. the sub-form appears). Closing the form will usually fix the problem, or in the worse case quiting the quick-starter.
phil, can you please check if in your scenario, the "add data only" property of the sub form has been implicitly set to "yes" during your filter operations?
No, it is set as "no" on the form and the macro does not attempt to change it.
> No, it is set as "no" on the form and the macro does not attempt to > change it Hmm .... (there was a bug that this was implicitly changed) ...
phil, because I am lazy: Do you mind creating a small sample document (.sxw, plus .dbf or e.g. a MySQL script creating sample tables) which would help reproducing this?
phil, I could reproduce this as described by you, but in my scenario it's really about the "add data only" property: when the filter is applied the first time, this property is changed to "yes" for the sub form, which causes it to _not_ display non-existent records. So unless you can provide an example for this bug which does not incorporate the "add data only" property of the sub form, I fear this is a duplicate of issue 11879.
As always Frank you are correct. The sub-form is changed to Add Data Only=Yes after the first zero-result filter. Marking this a duplicate of issue 11879. Thanks again... *** This issue has been marked as a duplicate of 11879 ***
> The sub-form is changed to Add Data Only=Yes after the first > zero-result filter closing then ... thanks.
change subcomponent to 'none'