https://bugs.documentfoundation.org/show_bug.cgi?id=166861
Bug ID: 166861
Summary: Libresoft Base should have a filter feature
Product: LibreOffice
Version: 7.3 all versions
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Base
Assignee: [email protected]
Reporter: [email protected]
Description:
Noticed that many of the item boxs for database information allows me to input
new information. However, with forms and queries and reports, I don't have a
feature to "filter" information to a search query.
Shouldn't there be a feature that shows an obvious search box for it that
allows search for specific details, so specific details of one database line
can be changed.
Steps to Reproduce:
1.Go under "Database" window. Select Queries, Forms, or Reports and use the
"Use Wizard to Create (Query/Form/Report)"
2.Define your parameters in the first few steps of the Wizard.
3A. In Query Wizard, go to "Step 3: Search Conditions". You should be able to
define which Field you would like to search through and what text or date or
binary action or information you are looking to filter through. Currently the
options are only mathematical. Can you add a search feature to the area which
automatically defines as "is equal to". Can we create a "search for" for text
options. You will realize that any feature search with text automatically
displays an wizard error.
3B. In the "Forms" wizard, it looks like the subform is setup as a search and
filter option, but nothing in the window articulates to any functional use of
it. Adding some text "search, filter, find" etc can go a long ways to identify
it. If the "Subform" has another function, then a additonal step should be
able to align a Field and search for an similar keyword phrase based on an
additional textbox in the form.
3C. In Reports, before the "Sorting Options", there should be a "Search and
Filter" option, which allows you to pick one or two of the fields you selected
from the group and define a filter function by keyword, binary status
(active/inactive), or equivalent number or date.
Actual Results:
3A. In Query Wizard, go to "Step 3: Search Conditions". You should be able to
define which Field you would like to search through and what text or date or
binary action or information you are looking to filter through. Currently the
options are only mathematical.
3B. In the "Forms" wizard, it looks like the subform is setup as a search and
filter option, but nothing in the window articulates to any functional use of
it. Adding some text "search, filter, find" etc can go a long ways to identify
it.
3C. In Reports, before the "Sorting Options", there is no feature I can see
that allows any filtering of information to reduce a database down to a few key
"similar fields".
Expected Results:
3A. Can you add a search feature to the area which automatically defines as "is
equal to". Can we create a "search for keywords" for text options. You will
realize that any feature search with text automatically displays an wizard
error.
3B. If the "Subform" has another function, then a additonal step should be able
to align a Field and search for an similar keyword phrase based on an
additional textbox in the form.
3C. In Reports, before the "Sorting Options", there should be a "Search and
Filter" option, which allows you to pick one or two of the fields you selected
from the group and define a filter function by keyword, binary status
(active/inactive), or equivalent number or date.
Reproducible: Always
User Profile Reset: No
Additional Info:
This is technically an enhancement, however, the software is missing a key
feature in database altering that makes adjustments quicker using forms. This
could be a highlighted feature to make task excessively quicker (compared to
looking line by line for the datapoint you are looking to retrieve.
Also, forms allow a certain protection of database alteration, so keeping only
a search/sort feature only in the database table looses a lot of protective
features for it.
--
You are receiving this mail because:
You are the assignee for the bug.
