To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=114492
Issue #|114492
Summary|Base form: Master/Slave Fields not working in combinat
|ion with OR filter
Component|Database access
Version|OOo 3.2.1
Platform|HP
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|none
Assigned to|dbaneedsconfirm
Reported by|martijn_v
------- Additional comments from martij...@openoffice.org Tue Sep 14 12:20:32
+0000 2010 -------
I have a base document with forms, using an Oracle Datasource.
One of the forms consists of a mainform, a subform (and a subsubform). The
subform is linked to the mainform using master/slave field set in the properties
of the subform. Normally this means the subform will only display records which
belong to the selected record in the mainform. (There is a one to many relation
between the record in the mainform and that in the subform.)
However: on the subform I use a filter: when this is a one condition filter or a
multiple condition filter with an AND operator, the master/slave behaviour works
as expected. However if I link the filter conditions with an OR operator, the
subform displays all the records which conform to the filter, instead of just
the records belonging to the selected mainform record.
Step by step:
1. Create a database with two tables with a one to many relationship (preferably
an Oracle database). The "many" table should contain at least 3 fields.
2. Create a form with a subform using the wizard, both are table style forms.
The mainform is for the table on the "one" side of the relationship, the subform
for the table on the "many" side.
3. In the subform properties, set the linked fields in both tables as the master
and slave fields, using the [...] button.
4. In the subform properties, define two filter conditions using the [...]
button. Use two different fields, neither of them should be slave field. Combine
the two conditions using OR.
5. Create a few records in the main table, with different values for the master
field (which is the primary key in my case). And create a couple of records in
the second table for each record in the main table. Make sure you have records
which comply to the filter conditions for each record in the main table.
6. Load the form. The subform will show all record which comply to the filter,
no matter which record is selected in the mainform.
7. Edit the subform filter, replace OR with AND.
8. Load the form. The subform will now show only the records which belong to the
selected mainform record (and comply to the filter).
I hope this is clear enough. If not ask me for clarification. I'm using filters
of the type "null" by the way. But another type of filter ("not null" or ">" for
example) produces the same error.
Martijn
---------------------------------------------------------------------
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
