https://bugs.documentfoundation.org/show_bug.cgi?id=100367
Bug ID: 100367
Summary: Allow main form filtering by subform values with
form-based filter
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
If I'm not mistaken, when doing a form-based filter in a form containing a
subform, if the user enters some criteria in one of the fields of the main form
and another criteria in one of the fields of the subform, the current behaviour
of Base is to first filter the items (table/query) in the first form and then,
when visualizing each item using the navigation bar, filter the linked records
of the subform by the specified criteria.
For example, suppose we have a customers table including a zip code
column/field, and a 1:N relationship with a year_sales, in which, for each
customer/year (compound key) we have the sum of the total sales for that
customer.
Assume we also have a form for editing customers details, including a subform
for editing the data for year-total sales using a table control or any other
similar mechanism. That is: a single form allow us to add/edit all the data for
that customer.
With the current behaviour/implementation, however, the only way to filter all
customers with a combination of zip codes and total sales wound be to (a)
define a query to obtain them (not using form-based filter) or (b) use some
kind of single-record-search-table in a dedicated form.
It would be great to use *the same* add/edit form for the customer/sales tables
in order to perform this filter. In this case, the behaviour should change and,
instead of filtering first by zip code and, after that, when visualizing each
found customer, filtering its sales data by amount, the desired behaviour
should be to filter *simultaneously* by all the conditions, that is, obtaining
the list of customers that accomplish with any of the specified (combined)
filters.
Of course, this should not override the original, working-as-spected, current
implementation of form-based filtering. Perhaps the easiest way to allow this
would be to allow the user to specify that a criteria entered for a subform
field/column should work as a primary filter by using right-click and some
specific preference, and that should be either marked with some visual hint in
the form-based tree or be in a separated subtree in that tree, that hosts all
subform criteria that apply in first level.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
